Bug 140979 - Paste Special with Transpose does not respect visibility of cells
Summary: Paste Special with Transpose does not respect visibility of cells
Status: RESOLVED DUPLICATE of bug 107348
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-03-12 11:48 UTC by burnuser2
Modified: 2021-03-12 17:36 UTC (History)
0 users

See Also:
Crash report or crash signature:

demonstration of the bug (10.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-03-12 11:50 UTC, burnuser2

Note You need to log in before you can comment on or make changes to this bug.
Description burnuser2 2021-03-12 11:48:11 UTC
EDITING: Copy and Paste / Paste Special uses only visible (filtered) cells.
But Paste Special with option "Transpose" inserts also invisible cells!

Steps to Reproduce:
1. Make a number list, e.g. 1,2,3,4,5,6
2. Add beside a category list, e.g. a,b,a,b,a,b
3. Activate AutoFilter => select "a"
4. Copy visible numbers (e.g. 1,3,5)
5. Insert below with Paste or Paste Special => 1,3,5
6. Insert below with Paste Special + "Transpose" => 1,2,3,4,5

Actual Results:
non visible cells are inserted too, when using Paste Special with "Transpose"

Expected Results:
Same content pasted when using Paste / Paste Special /Paste Special + Transpose

Reproducible: Always

User Profile Reset: No

Additional Info:
see attached example
(Test with LO and LO
Comment 1 burnuser2 2021-03-12 11:50:19 UTC
Created attachment 170435 [details]
demonstration of the bug
Comment 2 Timur 2021-03-12 17:36:21 UTC
Looks duplicate. 
Please search before submitting.

*** This bug has been marked as a duplicate of bug 107348 ***