[Libreoffice-bugs] [Bug 134802] New: Paste values-only with "transposed" flag does not transpose output

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134802

            Bug ID: 134802
           Summary: Paste values-only with "transposed" flag does not
                    transpose output
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rafael.palma.lima at gmail.com

I am using LO Calc 6.4.4.2 on Ubuntu 20.04. When I copy a range of cells
containing formulas (ex: a column of numbers resulting from a formula) and I
want to copy and paste the values transposed onto a row, it keeps pasting
values as a column.

Steps to reproduce:
1 - Create a column of formulas resulting in numbers
2 - Ctrl-C to copy the cells containing the formula results
3 - Ctrl + Shift + V to open Paste Special dialog
4 - Check the "Transpose" option
5 - Click "Paste Values-Only" button at the top left corner of the dialog

Results: It paste the values, but without transposing them

Note that if I click the "Transpose" button at the top right corner of the
dialog and uncheck the "Formula" option, it will still paste the transposed
Formulas.

I think there is either a bug here of at least some inconsistency with this
dialog box.

In any case, I cannot paste transposed values.

-- 
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/20200714/b246a71c/attachment.htm>