https://bugs.documentfoundation.org/show_bug.cgi?id=160515
Bug ID: 160515 Summary: FILEOPEN XLSX Formula referencing Pivot table cells leaves incorrect result after pivot table resizing Product: LibreOffice Version: 4.3.0.4 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: kelem...@ubuntu.com Blocks: 112416 Created attachment 193480 --> https://bugs.documentfoundation.org/attachment.cgi?id=193480&action=edit Example file from Excel 2016 Attached Excel made file contains a pivot table and on another sheet some simple formula referencing the range where pivot results are expected. When the pivot table is resized, the last entry on the other sheet remains, leaving an incorrect result. 1. Open attached file 2. Go to the Query sheet, observe it's filled with non-0 values until row 35 3. Go to the Costs sheet and change the filter in B1, uncheck the D5 entry 4. Go back to the Query sheet -> Row 35 is still filled, but rows before it are not anymore Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c9d4f99b2bb54ac7735b3e0d0cadbafbd0279518 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default Seems to have started in 4.3 with: https://cgit.freedesktop.org/libreoffice/core/commit/?id=aa5ad7b8096cd15a55c467b1a23d03849aeb870d author Kohei Yoshida <kohei.yosh...@collabora.com> 2014-03-10 17:03:52 -0400 committer Kohei Yoshida <kohei.yosh...@collabora.com> 2014-03-10 17:28:54 -0400 commit aa5ad7b8096cd15a55c467b1a23d03849aeb870d (patch) fdo#74747: Make use of cached string formula results. But before this B35 was just empty, and values in column A were also present in the filtered out rows as well (this was solved in 4.4), so not really good either. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=112416 [Bug 112416] [META] XLSX (OOXML) pivot table bugs -- You are receiving this mail because: You are the assignee for the bug.