https://bugs.documentfoundation.org/show_bug.cgi?id=124651
Bug ID: 124651
Summary: Pivot table: saving this ODS as XLSX produces a file
that makes Excel warn and delete pivot table
Product: LibreOffice
Version: 6.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 150658
--> https://bugs.documentfoundation.org/attachment.cgi?id=150658&action=edit
A simplest pivot table ever
Saving this ODS as XLSX produces a file that makes Excel 2016 warn:
> We found a problem with some content in "0group.xlsx". Do you want us to
> recover as much as we can? If you trust the source of this workbook, click
> Yes.
and then delete pivot table:
> Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part
> (PivotTable view)
Adding "name" attribute equal to empty string to
/pivotTableDefinition/dataFields/dataField in xl/pivotTables/pivotTable1.xml
makes Excel consume the file normally.
Looks like a bug in Excel, since ECMA-376 Part 1 defines CT_DataField's "name"
attribute to be optional.
Tested with Version: 6.2.3.1 (x64)
Build ID: 9ba025bafb03b962c34687cf87806cc03a3a7436
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
