https://bugs.freedesktop.org/show_bug.cgi?id=64647
--- Comment #6 from ign_christian <[email protected]> --- Created attachment 80031 --> https://bugs.freedesktop.org/attachment.cgi?id=80031&action=edit Working file Let me try with a simple test sample. I attached Test1.xls & Test2.xls later. To see the problem: (Problem A) 1. Open Test1.xls 2. Cells B1-B5 is linked to Sheet1.A1-A5 on Test2.xls -> change cells B1-B5 to appropriate location of Test2.xls (eg. cell B1 ='file:///C:/Users/xxxx/Test2.xls'#$Sheet1.A1) 3. Mark all rows A1-A9 > Data > Sort > Column C > Ascending > OK 4. See that B6-B9 returns 0 because that cells produce wrong reference on Test2.xls Problem A: reference to another file not remembered properly while sorting @winkelmann: is that what you mean? similar with bug 45146 Another problem: (Problem B) 1. & 2. same as above 3. Mark all rows A1-A5 > Data > Sort > Column B > Descending > OK 4. See that B1-B5 don't change, seems like not moving at all Problem B: column that has reference to another file not moving while sorting if the column used as Sort Key -- 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
