[Libreoffice-bugs] [Bug 123939] New: Excel emits content warning opening LO-generated XLSX, when pivot table references columns with only strings and errors

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123939

            Bug ID: 123939
           Summary: Excel emits content warning opening LO-generated XLSX,
                    when pivot table references columns with only strings
                    and errors
           Product: LibreOffice
           Version: 6.2.1.1 rc
          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 149815
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149815&action=edit
Pivot table references a column with a string and an error

If a column only contains strings *and* errors, and is referenced in a pivot
table, then XLSX generated from such a spreadsheet emits a warning when opened
with Excel:

> We found a problem with some content in `file.xlsx`. Do you want us to try to
> recover as much as we can? If you trust the source of this workbook, click Yes.

This is because LibreOffice writes containsMixedTypes="1" attribute to
corresponding sharedItems element in the pivot cache definition. But Excel
treats string and error as the same data type, so in this case, the attribute
should be omitted.

Saving attached sample to XLSX would produce such a document giving warning
when opened with Excel. It contains a 3-column 2-row sample data, first column
of it has one string and one formula giving an error (=NA()). All three columns
are referenced in the pivot table on the second sheet (but only two other are
used).

Tested with Version: 6.2.2.1 (x64)
Build ID: fcd633fb1bf21b0a99c9acb3ad6e526437947b01
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/20190308/89bece87/attachment.html>