[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 #22 from Mike Kaganski <mikekaganski at hotmail.com> ---
Let me try to explain it once more.

Any formula cell may be in two states:
a. Dirty;
b. Up-to-date.

A file may be in one of two modes:

1. Auto-calculation off;
2. Auto-calculation on.

In either mode, a change in a data marks its dependencies dirty. But in mode
#1, this does not trigger following auto-calculation.

Auto-calculation (when active) creates a list of all dirty cells in the file,
and calculates *those cells*.

Which means that *cells that are not dirty are not recalculated*. It is
expected that all non-dirty cells already have correct data - that must be
guaranteed by previous calculations that made them up-to-date.

When you open a file that has auto-calculation enabled, all cached cell values
in it are considered correct, and are assigned to cells which are marked
up-to-date, which means that they are not recalculated unless something
modifies their referenced data.

This file has auto-calculated data. It has cached data, which is considered
correct. It was generated by a version with a bug, which violated this
assumption. That bug needed to be fixed, to stop producing wrong files. It had
been done. But old files from that buggy version still contain wrong calculated
data, which violates the assumptions..

-- 
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/20200906/50b73666/attachment.htm>