<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#c17">Comment # 17</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:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to BogdanB from <a href="show_bug.cgi?id=136465#c16">comment #16</a>) 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).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>