Description: Open the attached XLS file and save it as XlSX, when opening the resulting file in Excel, Excel throws an error Open the original XLS file in Excel, in "List1" sheet check Conditional Formatting rules (Home Tab > Conditional Formatting > Manage Rules) there are only 5 rules here. Do the same in LO, in "List1" sheet open (Format > Conditional > Manage..), here we see 6 rules, one extra rule with formula `(#NAME?,B$10,"+")`, this is an external formula which Microsoft Excel ignores, but LO imports So when exporting to XLSX we export this external formula in conditional formatting, which is causing the problem Solution is to skip import of external formulas during XLS import. Steps to Reproduce: 1. Open the attached XLS file 2. Save it as XLSX file 3. Open the resulting file in Microsoft 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 204969 [details] XLS File
Karthik Godha committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8f1d98092b0b3ed8879e51f04b17e6901b77f905 tdf#170263: Skip external formulas in Conditional Formatting It will be available in 26.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Karthik Godha committed a patch related to this issue. It has been pushed to "libreoffice-26-2": https://git.libreoffice.org/core/commit/52577897a856b5d46825da5d736d7fb708198bb5 tdf#170263: Skip external formulas in Conditional Formatting It will be available in 26.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.