https://bugs.documentfoundation.org/show_bug.cgi?id=112306
Bug ID: 112306
Summary: FILESAVE: An XLSX gives warning about Pivot Table
cache on opening in Excel after saving in Calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 136142
--> https://bugs.documentfoundation.org/attachment.cgi?id=136142&action=edit
Pivot table with blanks-only field
After fixing bug 89139, a problem still exists, that is visible with attached
document.
When opened and saved in Calc, it gives a warning on opening in Excel:
"We found a problem with some content in "BlankOnly.xlsx". Do you want to try
to recover as much as we can? If you trust the source of this workbook, click
Yes."
and then
"Repaired Records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"
The problem is that Calc writes `containsSemiMixedTypes="0"` attribute for
blank-only field. It seems to be consistent with the attribute's definition in
ECMA-376-1:2016, where it is stated that it is only true if the field contains
text values. Still, if only blanks are present (no strings), it is expected to
be true by Excel.
--
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
