<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Multi range selection pasted transposed as links is not transposed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141683">141683</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Multi range selection pasted transposed as links is not transposed
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>info@scito.ch
</td>
</tr></table>
<p>
<div>
<pre>Description:
When a multi range selection is pasted transposed and as link, then the pasted
links are not transposed. Irrelevant whether rows or columns ranges are
selected.
It works when only pasted transposed.
Steps to Reproduce:
1. Open a new spreadsheet in Calc
2. Fill the cells A1:C3 with
1 11 111
2 12 112
3 13 113
case columns:
3. Select cells A1:A3
4. Press Ctrl and select cells C1:C3, hence 2 column ranges are selected
5. Goto cell A6
6. Edit > Paste Special > Paste Special > Paste Transposed
7. Goto cell A10
8. Edit > Paste Special > Paste Special > Enable As Link, Enable Transpose and
OK
case rows:
10. Select cells A1:C1
11. Press Ctrl and select A3:C3, hence 2 rows ranges are selected
12. Goto cell A14
13. Edit > Paste Special > Paste Special > Paste Transposed
14. Goto cell A19
15. Edit > Paste Special > Paste Special > Enable As Link, Enable Transpose and
OK
Actual Results:
The values shown after step 6 and 8 are not the same. The links in A10:C11 are
not transposed.
Step 8 shows
1 11 111
3 13 113
The values shown after step 13 and 15 are not the same. The links in A19:B21
are not transposed.
Step 15 shows
1 111
2 112
3 113
Expected Results:
The values shown after step 6 and 8 are the same. The links in A10:C11 are
transposed.
Step 8 shows
1 2 3
111 112 113
The values shown after step 13 and 15 are the same. The links in A19:B21 are
transposed.
Step 15 shows
1 3
11 13
111 113
Reproducible: Always
User Profile Reset: No
Additional Info:
I've found this issue while fixing and testing <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Pasting transpose of filtered data pastes unfiltered data"
href="show_bug.cgi?id=107348">bug 107348</a> and <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Pasting transpose of filtered data pastes unfiltered data"
href="show_bug.cgi?id=107348">bug 107348</a>.
Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.3; UI render: GL; VCL: kf5
Locale: de-CH (en_US.UTF-8); UI: de-DE
Calc: threaded
Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 238034a21248ff58f36aad74a7bf3bec163ad700
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>