Anything in Excel native formats (XLSX) that shows errors in Excel, by definition, should be considered broken (until explicitly proven to be an Excel bug). So - no, I would not consider any third-party application doing things differently compared to Excel on Excel’s files as “correct”.
(Interesting to know what has generated such a document; the metadata tells “Microsoft Excel”, but any third-party generator can write that.)
And what could add
CR to the sheets’ names (visible in the file’s
And the actual problem there is not
/ slash in the sheet name. Excel, by the way, doesn’t allow to use it in the sheet names. Editing XML to replace
_ makes both Excel and Calc happy.
Analysis (fixed).xlsx (8.5 KB)