Description: strange unexpected result when doing paste special transpose works when use formula same in Version: 7.3.7.2 Linux mint 21.3 Steps to Reproduce: 1.copy range 2.paste special transpose 3. Actual Results: unexpected result Expected Results: should transpose data selected Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 24.8.4.0.0+ (X86_64) / LibreOffice Community Build ID: 9fc54b966b2b9d423cf594cd385224b06986666f CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded same in: Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.7 Calc: threaded
Created attachment 197647 [details] paste special transpose
Thank you for submitting this report. Based on your file, I do not believe this to be a bug, but a function of the way the formulas lose proper reference when transposing in this manner. If instead of Paste Special -> Transpose, you select Paste Special -> Paste Special and select transpose + values only, you will see the transpose correctly applied. However, this is a static table once pasted. Another option may be to use Pivot Tables in place of the COUNTIF formulas.
(In reply to Elmar from comment #1) > Created attachment 197647 [details] > paste special transpose Please give exact steps to reproduce.
Seems the range B10:G20 is the cluprit. The column G contains all =COUNTIF($Mem.$L:$L;G$1) being "converted" into =COUNTIF($Mem.$L:$L;J$1), =COUNTIF($Mem.$L:$L;K$1), etc. In fact this should be correct with a variable column. I suggest to create a minimal example.