https://bugs.documentfoundation.org/show_bug.cgi?id=165378
Bug ID: 165378
Summary: FILESAVE XLSX Invalid named range gets saved into XLSX
format
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: filters and storage
Assignee: [email protected]
Reporter: [email protected]
Blocks: 104839, 109178
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 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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
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.
