Bug 165377 - Invalid named range gets saved into ODS format
Summary: Invalid named range gets saved into ODS format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Name
  Show dependency tree / graph
 
Reported: 2025-02-21 18:13 UTC by Aron Budea
Modified: 2025-02-21 18:24 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:13:20 UTC 
See steps in bug 165375, contracted into a single series here:

- Start a new spreadsheet,
- Rename sheet to "PDRHE com Extensão" (without quotes),
- Open Sheet -> Named Ranges and Expressions -> Define...,
- Enter some name, eg. "test",
- The Range is pre-filled, press Add.
- Open Sheet -> Named Ranges and Expressions -> Manage...,
- Rewrite the Range to the intended one: "$'PDRHE com Extensão'.$A$#ref!"
- Press OK.
- Save as ODS.

=> This range already shouldn't be added (see bug 165375), but it also gets saved into ODS, see attachment 199367 [details] from bug 165375, and a more complex example, attachment 50636 [details] from bug 40438 (no idea how the invalid names ended up there).

Alternative steps would be to load and save back those attachments into ODS.

Apart from correcting the UI in bug 165375, there should be a mechanism preventing saving and loading invalid ranges into ODS format.
This could be automatic, but it would be best to notify 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) / Windows.
In 3.3.0 the complete steps can't be performed, but the bug is reproducible by opening and saving the sample ODS.