https://bugs.freedesktop.org/show_bug.cgi?id=77018
--- Comment #3 from Laurent BP <[email protected]> --- Created attachment 100089 --> https://bugs.freedesktop.org/attachment.cgi?id=100089&action=edit Zip containing 2 files linked. Open test.ods I propose a new simpler test file which compares behavior of sorting with absolute or relative references, with external/internal to other sheet/internal same sheet references. 1. Extract both files in the same directory 2. Open test.ods 3. Accept to update links 4. Select A15:D20 or A23:D28 (if you want to test absolute or relative references) 5. Sort descending according to column A Expected behavior: With relative external references or relative internal references to other sheet, formulas should be changed to reflect the new order. Current behavior: Formulas with relative external references are not updated. For relative internal to other sheet references, behavior changed between LibO 4.2.4.2 and LibO 4.3.0.0 beta1: with 4.2 and prior, formulas ARE updated; with 4.3 formulas are no more updated (but this may be another bug). No problem with absolute references. For relative internal references to the same sheet, formulas can be updated only if source is also sorted: move Feuille1.A1:A6 to Feuille1.E15:E20 and select A15:E20 before sorting. Then formulas are correctly updated. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
