Created attachment 199408 [details] Sample XLS #1 Save either of the attached XLS samples as XLSX, and try opening them in Excel. => Excel fails to open the XLSX, and when attempting repair, shows similar error: Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view) Removed Records: Workbook properties from /xl/workbook.xml part (Workbook) Observed using LO 25.8.0.0.alpha0+ (41ab24cecd6ad74312843f113d2faa13259cdb7d) / Windows. This is a regression from the following commit in 6.0: https://cgit.freedesktop.org/libreoffice/core/commit/?id=7c429ddca63c09a2b656715292968000bfe86a1a https://git.libreoffice.org/core/commit/7c429ddca63c09a2b656715292968000bfe86a1a author Tamás Zolnai <tamas.zolnai@collabora.com> 2017-09-09 11:06:19 +0200 committer Tamás Zolnai <tamas.zolnai@collabora.com> 2017-09-09 12:13:53 +0200 tdf#112278: Pivot table: filtering of non-string fields is not exported to XLS
Created attachment 199409 [details] Sample XLS #2
Created attachment 199410 [details] Sample XLS #3
Created attachment 199413 [details] Sample #1 resaved in MSO as XLS I tested with all 3. If I resave XLS as XLS in MSO, saving to XLSX works. This is still the bug, as MSO can save and reopen, but with low priority. Looking before referenced commit, Excel would open the file but without table being pivot. So this is not a regression, and is properly marked as implementationError.
Created attachment 199414 [details] Sample #1 resaved in MSO as XLSX This is about source XLS but let me add MSO saved XLSX for possible further test.