[Libreoffice-bugs] [Bug 130118] error in calculating sums

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
(In reply to Alex Thurgood from comment #8)
> This debate comes up again and again.
Yes.

> I notice that hard recalculate doesn't set the flag "changed", so the user
> can not know that a save is necessary. 
That might had been even on purpose because there may be various reasons why
(portions) are recalculated and not all are wanted to trigger a "save this"
state. We probably should do that at least after a manual hard recalc.

> I don't understand why cell N8 isn't calculated correctly on opening the
> file. 
Because files are not generally recalculated upon open. You normally don't want
that, specifically not with more complicated documents. The point here in this
case is that once in history the file was saved with wrong results (probably
due to some other bug that miscalculated a grouped shared formula, the creator
is old LibreOffice/5.3.3.2), and the file is opened preserving those results,
hence has to be recalculated once and saved.

> I'm sure this has come up before in some other bug report...
Probably. I don't recall a bug number.

-- 
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/20200128/e82d3af8/attachment.htm>