[Libreoffice-bugs] [Bug 142556] FILEOPEN, EDITING, Cell with syntax ==IF() displays a result, no error, corrupts calculations and user profile

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142556

Lars Jødal <lajo at rn.dk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |lajo at rn.dk

--- Comment #7 from Lars Jødal <lajo at rn.dk> ---
(In reply to Eike Rathke from comment #3)
[...]
> Note the explanatory text for "forced recalculation" is wrong, instead of
> "should be recalculated whenever one of its predecessors it depends on
> changes" (which of course is the normal behaviour) it should be "should be
> recalculated whenever recalculation occurs, not only when one of its
> predecessors it depends on changes".

Some thoughts on undo:

Should recalculation occur or not at "undo"? If undo is implemented as
restoring the previous values, then no recalculation is needed. But in that
case, a formula with == should be right in any case (as I understand the
explanation).

Well, a small test seems to show that undo does cause at least some
recalculation. A cell with the formula "=RANDOM()" or "==RANDOM()" gets a
random number in the interval [0,1[, and the number is renewed on every
recalculation. For instance, it changes when "del" is pressed in any cell. Now,
Ctrl-Z does NOT change the contents back to the previous value but to a new
random number (for both = and ==). So it seems that recalculation (rather than
storing) occurs.

Well, I don't know if this brings in anything new, but the original description
was tied to undo.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210531/b14886b2/attachment.htm>