https://bugs.freedesktop.org/show_bug.cgi?id=81633
--- Comment #46 from Fred Olness <oln...@smu.edu> ---
A COMPACT EXAMPLE OF THE BUG: ===================
Here is a compact example of the bug.
This is now fixed in the 4.3.4.0.0 2014-10-09 development version. (Thank you)
Note, this is clearly a BUG and not a FEATURE as this bug would break
imported spreadsheets from other programs (Excel, Gnumeric, ...)
In particular, this broke all my course grading spreadsheets.
EXAMPLE: if I consider the following spreadsheet
(which is sorted on the 1st column):
-----------------------------------------------------------------
ann fff =E1+F1+G1 =SUM(E1:G1) 1 2 3
barney eee =E2+F2+G2 =SUM(E2:G2) 4 5 6
charlie ddd =E3+F3+G3 =SUM(E3:G3) 7 8 9
-----------------------------------------------------------------
If I now sort on the 2nd column {ddd,eee,fff} the result is WRONG:
-----------------------------------------------------------------
charlie ddd =E1+F1+G1 =SUM(E3:G3) 7 8 9
barney eee =E2+F2+G2 =SUM(E2:G2) 4 5 6
ann fff =E3+F3+G3 =SUM(E1:G1) 1 2 3
-----------------------------------------------------------------
Note the relative references are handled correctly when I use
"=E1+F1+G1" but not when they are inside the argument of the
function: "=SUM(E3:G3)"
--
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
