Created attachment 63271 [details] testing file 1 - Open attached file. File is created in OOo. 2 - Go to sheet "servisni zasahy" 3 - Right click on first pivot table-> Refresh Actual results: Sum of Typ servisu=1 is 1528990992 Expected results Sum of Typ servisu=1 is 314352
Please don't set a bug a blocker! This is not a blocker!
Looking into this.
Wow. I don't even know where that number (1528990992) comes from.
Ah. This is a manifestation of a bug where the pivot table calculates incorrectly when the specified data range is includes a whole bunch of empty rows. Good catch!
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f2ac4ff6600a7d20a519e9ef9e6bcd8157288f63 fdo#51266: Properly set pivot item 'empty' on empty cells.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6d91eaaf8695da3f0da767f2669fcc650e9a76a5&g=libreoffice-3-6 fdo#51266: Properly set pivot item 'empty' on empty cells. It will be available in LibreOffice 3.6.
Note that this commit alone will not fix the problem in its entirety. There is an additional problem I need to solve which I'm currently working on.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fa2b7eff2d40b6455970b521306c5961e4e3cec4 fdo#51266: Sync dimension members in several places upon refresh.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fcc90b132168405e5a862fa4db8cfdcdcf632f65&g=libreoffice-3-6 fdo#51266: Sync dimension members in several places upon refresh. It will be available in LibreOffice 3.6.
After this commit, I'm no longer able to reproduce the bug. I'll call it fixed.