Bug 165378 - FILESAVE XLSX Invalid named range gets saved into XLSX format
Summary: FILESAVE XLSX Invalid named range gets saved into XLSX format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Corrupted Cell-Name
  Show dependency tree / graph
 
Reported: 2025-02-21 18:24 UTC by Aron Budea
Modified: 2025-02-21 18:32 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 2025-02-21 18:24:59 UTC 
This is the XLSX counterpart of bug 165377. The additional problem is that Excel complains about the invalid file, and the named range gets removed.

Perform steps from bug 165377, except save as XLSX at the end, or simply open attachment 199367 [details] from bug 165375, and save as XLSX.
Open the XLSX in Excel.

-> Excel complains about the invalid file.

This particular named range is invalid, but I'm not sure if otherwise there are names that are valid in ODS and not in XLSX. Those should be considered as well.

Noting the same comment as in bug 165377:
This could be automatic, but it would be best to notify the user about the problem, which might help figuring out if invalid ranges are created in an obscure, unnoticed way.

Observed using LO 25.8.0.0.alpha0+ (41ab24cecd6ad74312843f113d2faa13259cdb7d) and 3.3.0 / Windows.