[Libreoffice-bugs] [Bug 136465] Cell contains incorrect value from formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #17 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to BogdanB from comment #16)

I don't know which exact circumstances caused not recalculating of this
specific cell in 5.1. Reverse bisecting of the fix could possibly tell. However
imagine this scenario: that file was initially set to not recalculate
automatically. In that mode, some edits were made, and finally auto-calculation
was enabled. That made all values to recalculate at that moment, but the bug
prevented refreshing the value in this cell. Which made the save to store this
cached value into the file.

Note that normal behavior of Calc is to only recalculate "dirty" cells (i.e.,
those which were made out-of-date by some changes in the referred cells, or
having volatile functions like NOW or RANDOM. This allows to skip recalculation
of known-correct values; of course, it's assumed that all previous calculations
were correct (and when it's not so, that's a bug).

-- 
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/20200905/dcaacac6/attachment.htm>