[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 #27 from Alan Jones <ajones2001 at googlemail.com> ---
I have just found another aspect to this problem.

I opened the file on version 6.3.1.2 on a Mac.
pressed F9 on the 1803.10 cell, the value updated to 1824.99 -great

Closed the file
Reopened the file and the value was back at 1803,   WAT!, "cached" value?

It would appear that when a value is updated from the cached value it does not
mark the file as changed and hence the updated value isn't saved.  I have tried
with a few different versions (but not the newest) and this behavior is
consistent.  I can work around this too, but this problem gets more incidious
the more we look at it.

I humbly suggest that Caching is generally a bad idea, is there an option to
disable it altogether?    If not then I propose that this option be added so
that people who really want the values caching can have that feature.  The rest
of us that would prefer to have "Reliable" values can turn it off and have the
sheet recalculate on load, we have to recalculate anyway based on these
findings.

-- 
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/b30ced06/attachment-0001.htm>