Created attachment 203168 [details] Example file from Excel The data of the attached Excel-made file contains some cells with #N/A error, which are used in a pivot table. When this is roundtripped in Calc with German UI language (but not English), the resulting file loses the pivot table when opened in Excel. 1. Set UI language and locale to German 2. Open attached file in Calc 3. Save as XLSX 4. Open the resulting file in Excel -> Error is shown about invalid content: Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view) Removed Records: Workbook properties from /xl/workbook.xml part (Workbook) Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 708abf24664a9a1aaeac452bcc8436026030e74e CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: de-DE (hu_HU); UI: de-DE Calc: threaded Seems to be a case ever since 3.3, not a recent regression.
Created attachment 203169 [details] The example file saved with Calc master, in German UI
Created attachment 203170 [details] The example file saved with Calc master, in English UI The suspicious part is in xl/pivotCache/pivotCacheDefinition1.xml: <cacheField name="Err" numFmtId="0"> <sharedItems count="2"> <s v="abc"/> <e v="#N/A"/> </sharedItems> </cacheField> This is good in English saved version, but bad in German saved one: <cacheField name="Err" numFmtId="0"> <sharedItems count="2"> <s v="abc"/> <e v="#NV"/> </sharedItems> </cacheField>