Created attachment 107129 [details]
Sheet with two tables which show the situation before and after the sorting attempt
Steps to reproduce:
1. Create a table where one column (e.g. A) counts values of other cells in the same line by using something like =COUNTIF(B2:D2;"x") in cell A2.
2. Sort the table by this column.
The table is corrupted, does not even look sorted, and some (not all) cell references refer to wrong lines.
The table is nicely sorted, and all cell references still refer to the same lines as the formulas.
Operating System: Ubuntu
Version: 18.104.22.168 release
In LibreOffice Calc 22.214.171.124 this error does not exist.
Hi Martin, new behavior of internal sorting changed since 4.3.1 and 4.2.7
Please take a look at Bug 81633 and all related bugs. Perhaps you're reporting a duplicate?
Tested with version 126.96.36.199, Win7 - sorting is correct. Please test with newer version. Thank you.
I can also confirm: not reproducible with LO 188.8.131.52, Win 8.1, German
Confirm wrong behavior (as displayed on attached file) with LO 184.108.40.206 portable - Win7 x86
Confirm correct behavior with LO 220.127.116.11, 18.104.22.168 portable
@Martin, please upgrade to 22.214.171.124
Confirmed: Bug no longer exists in Version 126.96.36.199 (Linux 64 bits).
In fact this bug is a duplicate of bug 79441.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 79441 ***