https://bugs.freedesktop.org/show_bug.cgi?id=45146
--- Comment #39 from helplibreoff...@mailcatch.com --- While testing this issue, I found an unrelated issue (82915), and creating a separate bug report for that. When doing so, I realized that the spreadsheet I posted in post #27 of this thread was not properly edited when I simplified it by hand for this bug report. Here's how it should have looked: 2014-04-01 SubAssembly1 =C$2+C$3 2014-02-01 Nuts 10 2014-03-01 Bolts 5 2014-04-01 SubAssembly2 =C2+C3 2014-01-01 Grease 50 2014-05-01 Assembly1 =C4+C5 2014-05-01 Assembly2 =C$1+C$5 BTW, the example intentionally uses 2 different types of references for testing purposes of the bug reported in this thread. If people can try sorting by columns A, B, and C to verify that LO Calc now produces expected results, that would be appreciated. I only had time today to perform a quick test using v4.3.0.4, and it appeared to now work as expected. This of course does not test any issues related to referencing other sheets as reported by others. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs