[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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #15 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Alan Jones from comment #13)
> I can confirm that CTRL shift F9 does recalculate the cell.

Thanks for reporting! Good to know; this confirms comment 6.

> 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] https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

-- 
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/20200905/daa5b05d/attachment.htm>