https://bugs.documentfoundation.org/show_bug.cgi?id=168727
Bug ID: 168727
Summary: FILESAVE XLSX Pivot table with #N/A error is invalid
when opened in Excel
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 104839, 112416
Created attachment 203168
--> https://bugs.documentfoundation.org/attachment.cgi?id=203168&action=edit
Example file from Excel
The data of the attached Excel-made file contains some cells with #N/A error,
which are used in a pivot table.
When this is roundtripped in Calc with German UI language (but not English),
the resulting file loses the pivot table when opened in Excel.
1. Set UI language and locale to German
2. Open attached file in Calc
3. Save as XLSX
4. Open the resulting file in Excel
-> Error is shown about invalid content:
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part
(PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 708abf24664a9a1aaeac452bcc8436026030e74e
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: de-DE (hu_HU); UI: de-DE
Calc: threaded
Seems to be a case ever since 3.3, not a recent regression.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
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.
