https://bugs.documentfoundation.org/show_bug.cgi?id=82135
Markus Mohrhard <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |NOTABUG
--- Comment #18 from Markus Mohrhard <[email protected]> ---
(In reply to Aron Budea from comment #17)
> Okay, I tested hard recalc, and F9 indeed doesn't work as expected in
> v5.1.5.2 (but Ctrl-Shift-F9 does), that is certainly a bug, and most likely
> unrelated to the change.
> However, both F9 and Ctrl-Shift-F9 works as expected in v5.2.1.2 with the
> example sheet.
> There is definitely another workaround if you change Tools -> Options ->
> LibreOffice Calc -> Formula -> Recalculation on File Load: Excel 2007 and
> newer.
>
> I'd ask how you would expect cached values to work, and why 0-s are stored
> in the file instead of reasonable values? It makes no sense to have invalid
> values cached there, and the point of having cached values is exactly that
> the software wouldn't have to calculate formulas during file opening. How
> does Excel work in this case that is different?
F9 is not a hard recalc. Only CTRL+SHIFT+F9 is. A soft recalc is only useful if
you disable automatic recalculation as it only recalculates dirty cells. The
hard recalculation (CTRL+SHIFT+F9) should correctly recalculate the cells.
The mentioned behaviour here is not a bug. We are using cached values and if
the file contains wrong values there is nothing we can do.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
