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

Reply via email to