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: [email protected]
Reporter: [email protected]
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 <[email protected]> 2014-03-10 17:03:52
-0400
committer Kohei Yoshida <[email protected]> 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.
