https://bugs.documentfoundation.org/show_bug.cgi?id=166143
Bug ID: 166143
Summary: FILEOPEN XLSX Pivot table not imported
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 112416
Created attachment 200296
--> https://bugs.documentfoundation.org/attachment.cgi?id=200296&action=edit
Example file from Excel 2016
Attached example file has a pivot table, whose source is a named range, which
is defined as a function.
This is not imported as a pivot table, only the cell text/number contents are.
Another pivot table in the file has its source as a named range, but directly
referring to the same cell range. This is imported fine.
Also there are some CountA function calls on the sheet, which demonstrate that
referring to the range works in another function as plain named range, as
function and as the named range defined as function.
1. Open attached document
-> The first pivot table is not imported, only the second.
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 22ef238e820955f6f8ac84781289b8a1d8e477b9
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded
seems like this has never worked.
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.
