Created attachment 108351 [details]
Spreadsheet demonstrating how formulae are incorrectly sorted
When sorting a table, formulae should not be sorted. However, in this release (18.104.22.168) formulae are being sorted. This breaks common usages, such as cumulative sums or counts.
The attached spreadsheet shows two simple tables, each with a column of random numbers and a column of row counts. The left table is unsorted, the right table sorted on its first column. When the first column is sorted, the second column (of row counts) is no longer correct.
Did you select Current selection in the Sort Range windows appearing when you ask for Sort?
Hi Jacques. No, I didn't make an explicit selection. I simply click on the column of interest and then click on the "Sort Descending" or "Sort Ascending" icon. This is the method I have typically used in versions past.
Let me know if you need any further info.
Indeed, whatever the choice made for the Calc configuration option "Update references when sorting range of cells", sorting gives the same result and it is different from the result given by LO 22.214.171.124, 4.1.6 and 4.0.6.
This case is similar to the case of bug 81633 and bug 85215 (attachment 108255 [details])
but it is different because in your case the configuration option seems to have no action.
Problem reproduced with
Build ID: 1df0656c4bb139606081625fb19e39fbef9f8890
Build ID: 0bb29affae83d0410f745f46267527e10777fcd2
both built at home under Ubuntu 14.04 x86-64
Best regards. JBF
It works if you sort only the data column (decline the invitation to extend the selection).
In LO 126.96.36.199.alpha1+:
- if option "Update references when sorting range of cells" is not checked (UpdateReferenceOnSort hidden option set to false in 188.8.131.52.0+) the formulas are not modified.
- if option "Update references when sorting range of cells" is checked (UpdateReferenceOnSort hidden option set to true in 184.108.40.206.0+) the formulas are modified but their values are still unchanged.
For me it is a duplicate of bug 81633. Feel free to reopen if you disagree. In this case, please, explain.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 81633 ***