Created attachment 106511 [details]
If yuo ordr the table ""Area_Dati" in the sheet "Inserimento dati" in the linked tables in the other sheets the order was changed too, now are changed the linked formulas insteed.
In this release of Libre Office if you order a table, in the linked tables on another sheet are changed the formulas; in earlier versions, formulas calculation remained unchanged and so it was possible to automatically obtain a sort of linked tables, it is now no longer possible (attached a sheet of example: ordering with a macro the list of the first sheet for the column "N.posto", before you got ordered tables on other sheets, it is'nt now no longer possiboile). A whole series of my spreadsheets become unusable in this way.
Steps to reproduce:
Operating System: Windows 7
Version: 126.96.36.199 release
Last worked in: 188.8.131.52 release
*** Bug 84052 has been marked as a duplicate of this bug. ***
Hi Gabriele..I think your file is too complex to observe (at least for me).
Could you please provide simple test case & exact reproducible steps? Without macros if possible, unless the problem is in macros.
Created attachment 106552 [details]
This is a simple worksheet with two tables in two sheets
In this ods file there are two tables in two sheets ("table" and "derived table").
The data are entered directly into the table on the first sheet.
In the table of the second sheet ("Derived table"), data are read from the table of the first sheet in an orderly manner by formulas in order to reproduce exactly the same table (albeit with a slightly different structure and formatting).
Ordering the first table, for a key ("N °" or "Position" or "NAME") the derived table in version 4.2.6 of LibreOffice is automatically ordered too and preserves the order of the first table, in 4.3 version of LibreOffice order of the derived table is not changed and are modified the references of the formulas instead.
STEP 1: Select the table in the first sheet (data - Select area - "DATA")
STEP 2: Order the data in the first table (data - order - ....
STEP 3: Wiew results in the second sheet ....
The results are completely different in the two versions of LibreOffice.
I need to keep the order of the first table in the derived tables and I could not find an alternative way to do it.
I hope this example file allows for easier understanding of the problem.
Thanks Gabriele. It's easier to understand now :)
Reproduced with LO 184.108.40.206, 220.127.116.11.0+ Time: 2014-09-11_14:25:14 under Ubuntu 12.04 x86
Not reproduced with LO 18.104.22.168, 22.214.171.124
Possibly it's because fixing of Bug 81309 that introduce new behavior of internal sorting.
This is not a regression and the change is intentional.
Also note Bug 81633 which makes this behavior configurable, though due to translation requirement it is for 4.4 only.
Same problem as in bug 81633 but in this case the configuration option in LO 4.4 works as expected.
Best regards. JBF
Just to say that 4.2.8, 4.3.5 and 4.4 will restore the old behavior. For releases that have the UpdateReferenceOnSort configuration option with the option set to false/unchecked, which is default.