Description: Open the attached XLS file and save it as XLSX, Excel throws an error when opening the resulting file. The XLS file contains external functions. Open the original file in Excel and look at the cell D32, we see a function `percent(B32,B$31)`. When we open same file in LibreOffice and look at cell D32 we see `(#NAME?, B32, B$31)`. So, when we export to XLSX we export this invalid external function which Excel doesn't accept Steps to Reproduce: 1. Open the attached XLS File 2. Save it as XLSX 3. Open the resulting file Excel Actual Results: Excel throws an error when opening the file Expected Results: Excel opens the file without any problem Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 22; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Calc: threaded
Created attachment 205124 [details] XLS File
It is also an error opening with Microsoft® Excel® para Microsoft 365 MSO (versión 2511 compilación 16.0.19426.20218) de 64 bits Saving in Excel as XLSX doesn't solve the issue.
I didn't notice that even Excel fails to open the file saved in Excel as XLSX :). Anyways I have a patch to properly import External functions, with this the resulting XLSX saved in LibreOffice opens in Excel without any problem. https://gerrit.libreoffice.org/c/core/+/197535