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)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
demonstration of the bug (10.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-03-12 11:50 UTC, burnuser2 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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 7.1.0.3 and LO 7.1.1.2)
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 ***