https://bugs.freedesktop.org/show_bug.cgi?id=64647
--- Comment #8 from [email protected] --- sorry for the delay. I had much work and this problem came up through this work. the described (Problem A) is the problem I am taling about. > 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 But I don't know if I refind it in this bug 45146. Sometimes the result is "0". Some rows loose their reference... -- 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
