Created attachment 205307 [details] Sample ODS Open the attached ODS, save it to XLSX and try opening it in Excel. It fails to open the file. The ODS contains the following unusual formula: - SUM() - gives result 0, but invalid in Excel, - MAX() - gives Err:511, but invalid in Excel, - MIN() - gives Err:511, but invalid in Excel. These should be exported in a way that the file can still be opened in Excel: SUM with an extra 0 argument, and MAX/MIN with some sort of error argument. (#VALUE! maybe)
Already in 3.5.0.3
Aron Budea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3cbf4957d33c7414b5cd02481136679b5c6a834e tdf#170565 save empty SUM/MAX/MIN functions with parameters to XLSX 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.
Aron Budea committed a patch related to this issue. It has been pushed to "libreoffice-26-2": https://git.libreoffice.org/core/commit/4a4cbf701ff556982f78848f8c44021b7edeb1d2 tdf#170565 save empty SUM/MAX/MIN functions with parameters to XLSX It will be available in 26.2.1. 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 "master": https://git.libreoffice.org/core/commit/8ea0c3678ffa87af77566add850b950361d17301 tdf#170565: Handle empty aggregate functions in XLSX 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/ae56f7fda59137a39329c8eead1bb4addf6569d8 tdf#170565: Handle empty aggregate functions in XLSX 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.