[Libreoffice-bugs] [Bug 124651] New: Pivot table: saving this ODS as XLSX produces a file that makes Excel warn and delete pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190410/87739f05/attachment.html>