Bug 170565 - FILESAVE XLSX SUM/MAX/MIN formula without arguments saved invalid
Summary: FILESAVE XLSX SUM/MAX/MIN formula without arguments saved invalid
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Aron Budea
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Corrupted Cell-Formula
  Show dependency tree / graph
 
Reported: 2026-02-02 04:31 UTC by Aron Budea
Modified: 2026-02-02 04:38 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Sample ODS (8.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-02-02 04:31 UTC, Aron Budea 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2026-02-02 04:31:44 UTC 
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)
Comment 1 Aron Budea 2026-02-02 04:38:06 UTC 
Already in 3.5.0.3