[Libreoffice-bugs] [Bug 140979] New: Paste Special with Transpose does not respect visibility of cells

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: burnuser2 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210312/620942a7/attachment.htm>