Created attachment 54816 [details]
A file with a pivot-table and a formula. The formula doesn't update correctly
When you have a formula which uses data from a pivot-table then it doesn't update the answer after a update in the pivot table.
In the attached ods:
When you change the date in the pivot-table then the cell E6 doesn't get updated correctly after the first change it the table. So the first time you change the pivot-table it does get updated. Afterwards not anymore. Version 3.4.2 does update it correctly.
I tried it on Ubuntu 10.04 on X86_64 and on Windows XP on X86.
Confirm with LO3.5beta2 on WinXP. Not only simple reference does not update, but the special function GETPIVOTDATA does not update too. You need a STRG+SHIFT+F9
BTW is this a regression or did it never work?
Let me know if this is a regression from an earlier version, or something that never worked.
I'll have to test this tomorrow at work. There I have LO 3.4.2 to test.
I have tested it on 3.4.2 on Windows XP. There it is slow but it works.
K. Thanks. I'll look into it.
Ok. So, let's not confuse the original reported bug with GETPIVOTDATA, which BTW works for me. If that doesn't work please file a different bug.
I'll stick with the originally reported bug.
(In reply to comment #7)
> Ok. So, let's not confuse the original reported bug with GETPIVOTDATA, which
> BTW works for me. If that doesn't work please file a different bug.
Ah. It's the filtering by the page field that's not working. And yup, GETPIVOTDATA doesn't get updated when you change the page field filter value. I was changing the date values in the original source range and refreshing the table, which updates the referencing cells correctly.
Ah. Actually refreshing the table only works for the first time too.
I've at least identified the commit that introduced this regression. It's the rework done in ScColumn::DeleteRange(). Looking further into this at the moment...
Fixed on master
and asking the list to have it cherry-picked to 3.5.
New patch replacing the old one on master
pushed also to 3-5
awaiting review for 3-5-0
Works fine with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit).
Menu 'Options -> Cell Contents -> Update' will not work
Toggling any checkbox in menu 'Tools -> Options -> Calc -> Calculate -> Input Settings' will make the values change, after a new paste - delete a new checkbox toggle will be necessary to update calculated values.
I am pretty sure that this one has the same roots like "Bug 45370 - EDITING: Calculated cell contents not updated after copy - paste - delete of source values"
Found pushed to 3-5-0 http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5-0&id=2d930ae25bb1ca90d0c186e7f34407bf1adfa54d
*** Bug 45370 has been marked as a duplicate of this bug. ***