[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 #13 from Alan Jones <ajones2001 at googlemail.com> ---
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

-- 
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/20200904/5861505c/attachment-0001.htm>