[Libreoffice-bugs] [Bug 112306] New: FILESAVE: An XLSX gives warning about Pivot Table cache on opening in Excel after saving in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

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