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

            Bug ID: 148516
           Summary: Formulas are not transposed correctly.
           Product: LibreOffice
           Version: 7.2.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Example: In Cell C1 is this formula: "=$A1"
The formula is pulled down to cell C26: "=$A26"

It should be transposed to the cells E1, F1, G1 and so on.

Result: After Rightclick "insert content" and "Transpose": In all cells stands
the same "=$A1". Expected: "=$A1" in E1, "=$A2" in F2, "=$A3" in F3 and so on. 

Steps to Reproduce:
1. Fill a cell with a simple formula like "=$B2" and pull it down for some
cells
2. copy the content to the clipboard
3. Right click on a cell where you want the transposition to start.
4. Choose "insert contend", then "Transpose"

Actual Results:
In all cells is the formula "=$B2".

Expected Results:
In first cell is "=$B2", in the next cell is "=$B3" and so on.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to