https://bugs.freedesktop.org/show_bug.cgi?id=80062
Modestas Vainius <geroma...@mailas.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |geroma...@mailas.com
--- Comment #4 from Modestas Vainius <geroma...@mailas.com> ---
I can confirm this issue on both 4.2.5.2 (Linux) and 4.3.0.2 (RC2) (windows).
It seems to affect more or less all formulas. But interestingly enough, some
formulas are recalculated on undo and it does seem to depend on row, column,
sheet and even reference count/width/height in the formula.
I attach speadsheet "undo_doesnt_recalc.ods" demonstrating this. All sheets
contain the same content. However:
1) If you delete content of any cell in Sheet1 Row 1 and undo it, you can see
as Row 1 formulas are recalculated and others are not. If you delete content on
other rows, no formulas are recalculated.
2) If you delete content of any cell in Sheet2 Row 2 and undo it, you can see
as Row 2 formulas are recalculated and others are not. If you delete content on
other rows, no formulas are recalculated.
3) If you delete content of any cell in Sheet3 Row 3 and undo it, you can see
as Row 3 formulas are recalculated and others are not. If you delete content on
other rows, no formulas are recalculated.
Do you see the pattern? It seems as if the same index variable in "reference
affected" loop is reused for row, column and sheet.
While not demonstrated in "undo_doesnt_recalc.ods", the rules above change if
formula =COUNT($A$1:$C$3) is replaced with =COUNT($A$1:$C$2). Then deleting
value in Sheet1.C1 no longer causes Row 1 formulas to recalculate. Likewise
deleting value in Sheet2.C2 no longer causes Row 2 formulas to recalculate. So
it seems to depend on range height and/or width as well.
This bug has almost already fooled me into sending wrong numbers to other
people. I think it is fairly critical.
--
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
