<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> changed <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> <table border="1" cellspacing="0" cellpadding="8"> <tr> <th>What</th> <th>Removed</th> <th>Added</th> </tr> <tr> <td style="text-align:right;">Status</td> <td>UNCONFIRMED </td> <td>RESOLVED </td> </tr> <tr> <td style="text-align:right;">Resolution</td> <td>--- </td> <td>WORKSFORME </td> </tr></table> <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#c15">Comment # 15</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 Alan Jones from <a href="show_bug.cgi?id=136465#c13">comment #13</a>) > I can confirm that CTRL shift F9 does recalculate the cell. Thanks for reporting! Good to know; this confirms <a href="show_bug.cgi?id=136465#c6">comment 6</a>. > Where is this in the menus? Indeed it was not in the menus in v.5.1 by default; it's added to the Data menu (Recalculate Hard) in a later version. Note however, that it's impossible to add every of many hundreds of available functions into menus; all of them are manually assignable using Tools->Customize. > Selecting the cell and pressing F9 does NOT update the value. Yes, in v.5.1 that is the problem (that I confirmed). It is resolved in 5.2. > 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. Displaying cached values is *not* a bug - this is the idea behind caching the values; you can make any other software that uses caching to behave similarly, e.g. Excel. But not refreshing on F9 or on changing of referenced data (with auto-calculation enabled) is. The proper fix is to prevent such things from happening, which obviously has already happened. > I will update my OS and install a newer version of Libreoffice, ubuntu 16.04 > doesn't have a newer version in the repository. You may use the related PPA [1]. > 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 :) So closing WORKSFORME (as it was fixed by an unknown commit). Thank you very much for reporting! [1] <a href="https://launchpad.net/~libreoffice/+archive/ubuntu/ppa">https://launchpad.net/~libreoffice/+archive/ubuntu/ppa</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>