<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Cell contains incorrect value from formula" href="https://bugs.documentfoundation.org/show_bug.cgi?id=136465#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - 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>Thanks for the rapid response: I can confirm that CTRL shift F9 does recalculate the cell. Where is this in the menus? Selecting the cell and pressing F9 does NOT update the value. I would say that displaying an incorrect value when loading from a file (or at any time that autocalculate is active) is not what the user would expect, and is a bug. This took me quite some time to figure out, I only became aware of it when I was changing the way the values were accumulated an the totals did not match. I will update my OS and install a newer version of Libreoffice, ubuntu 16.04 doesn't have a newer version in the repository. I will leave it to you to decide if the userbase needs to be made aware. I will use CTRL shift F9 often from now on :) Thanks</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>