Apache OpenOffice (AOO) Bugzilla – Issue 101845
Sorting fails for cells with links to different sheets (Unexpected results)
Last modified: 2009-05-13 17:18:02 UTC
In the ods attached there are shown 2 different behaviours: 1 - the normal expected result is shown in example 1. If you sort the range Timp.A1:G30 by column G for example, everything is ok, the formulas in column F are kept intact. 2 - in example 2, identical to example 1, on column G we make a reference to $Parametri.$B$3 instead of $N$2 (in the same sheet). If you sort now the same range Timp.A1:G30 by column G the formulas in column F are mixed up after sorting... You can check the same behaviour in the 3rd example, by sorting range Salarii.A2:AD29, by column AD. You will have unexpected results on columns: X, U, T, P, o, N, L, k, j, f, i. All these columns have in comon the reference to another sheet ($Parametri.$d$24 for example) So, the conclusion is that the sort doesn't modify corectly the references in formulas containing also refrences to other sheets, but work well for refrences in the same sheet. This was tested with the release 3.1, and I haven't seen it on previous releases. Please help!
Created attachment 62210 [details] Sort problem, example 1.ods
Created attachment 62211 [details] Sort problem, example 2.ods
Created attachment 62212 [details] Sort problem, example 3.ods
We have to switch back to release 3.0.1 wich works well in this situation. Please help!
Created attachment 62213 [details] Sort problem, example 4.ods
In example 4 we have submited the file reworked with 3.0.1 release. Also here there were some minor issues. But generally the sort works! **Please use example 4 instead of example 3, for testing on 3.1**
Same as 101690. *** This issue has been marked as a duplicate of 101690 ***
closing duplicate