[Libreoffice-bugs] [Bug 112407] VIEWING: cells with formulas referencing pivot tables contain stale / incorrect values until manual refresh

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112407

--- Comment #2 from Tomas <tv at fuzzy.cz> ---
(In reply to m.a.riosv from comment #1)
> I think has nothing to do with pivot tables, D3 and K3 doesn't change their
> values updating pivot table, edit Y3 add a space to get it modified without
> change and intro. it is recalculated, do a hard recalc [Ctrl+Shift+F9]
> 
> There is an option just to avoid this cases to recalculate on load.
> Menu/Tools/Options/LibreOffice Calc/Formula - Recalculation on file load.

You're right it may not be related to pivot tables - but what is the cause,
then? I mean, this is the first spreadsheet where I noticed this, so there has
to be something special about it. I wonder what is it?

The main problem for me was that the correct values were not saved, so after
re-opening the file the stale data was back. But Ctrl-Shift-F9 seems to fix
that, which is nice.

I don't think setting the "Recalculation on file load" really solves the issue.
It may solve it for me, but I need to share such spreadsheets with other
people, and who knows if they have this enabled.

-- 
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/20170916/805bd413/attachment.html>