https://bugs.documentfoundation.org/show_bug.cgi?id=140979
Bug ID: 140979
Summary: Paste Special with Transpose does not respect
visibility of cells
Product: LibreOffice
Version: 7.1.0.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs