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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
