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
Created attachment 179465 [details] example
Because the source references are all relative for row number, so when you transpose to row 1 all cell end with row 1 in them. Make the row absolute in the formulas, and they are transposed as you like. Transpose works like copy, no like move. In this case, you can do it easily. Copy A1:A26. With past special, do at the same time 'As link' and 'Transpose'