<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - Cell contains incorrect value from formula" href="https://bugs.documentfoundation.org/show_bug.cgi?id=136465#c27">Comment # 27</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - Cell contains incorrect value from formula" href="https://bugs.documentfoundation.org/show_bug.cgi?id=136465">bug 136465</a> from <a class="email" href="mailto:ajones2001@googlemail.com" title="Alan Jones <ajones2001@googlemail.com>"> Alan Jones</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>