https://bugs.documentfoundation.org/show_bug.cgi?id=165377
Bug ID: 165377
Summary: Invalid named range gets saved into ODS format
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: filters and storage
Assignee: [email protected]
Reporter: [email protected]
Blocks: 109178
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 from bug 165375, and a more complex
example, attachment 50636 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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=109178
[Bug 109178] [META] Named Cell Ranges and Formula Expressions bugs and
enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
