https://bugs.documentfoundation.org/show_bug.cgi?id=136465
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WORKSFORME
--- Comment #15 from Mike Kaganski <mikekagan...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
