Created attachment 136142 [details]
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."
"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.
A fix is under review: https://gerrit.libreoffice.org/42130
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":
tdf#112306: containsSemiMixedTypes is true for blanks-only
It will be available in 6.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
I reproduce with Excel Starter Kit 2010 under Windows 7.
I try the fix tomorrow.
(In reply to Jacques Guilleron from comment #3)
Thank you for looking!
Please set to verified if your testing will be successful.
Test file Opens without warning in Excel 2010
after saving in
LO 18.104.22.168.alpha0+ Build ID: ffeb750163909e15ee0dd2d16f8030bf08e66eae
CPU threads: 2; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@39, Branch:master, Time: 2017-09-11_06:33:01
Locale: fr-FR (fr_FR); Calc: CL
Have a nice day.