[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 #4 from Tomas <tv at fuzzy.cz> ---
(In reply to m.a.riosv from comment #3)
> After recalculation if I save the file, after reloading it looks fine.
> There is no way to solve this if wrong value was saved with the file.

Well, the question is what counts as recalculation. For me:

1) refresh pivot table + save : does not fix the issue (the values are
recalculated, but after reopening the file I get the stale data again)

2) refresh pivot table + edit cell + save : fixes the issue (adding a space to
a random cell is enough)

3) Ctrl+Shift+F9 + save : fixes the issue

Initially I was only doing (1), which was quite frustrating, as every time I
had to do it again after reopening the file. The fact that (2) fixes it makes
me a bit puzzled.

I don't really like (3) as it expects an action from everyone who gets the
file. If they fail to do that, they'll get incorrect data.

-- 
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/20170917/f597acf7/attachment.html>