Bug 160779 - Fileopen XLSX: protectedRange without name and sqref is invalid
Summary: Fileopen XLSX: protectedRange without name and sqref is invalid
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+ Master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted
  Show dependency treegraph
 
Reported: 2024-04-22 11:28 UTC by Timur
Modified: 2024-05-07 03:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample XLSX with short-hand protectedRange (19.54 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-22 11:28 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2024-04-22 11:28:55 UTC
Created attachment 193800 [details]
Sample XLSX with short-hand protectedRange

protectedRange of XLSX is not supported in LO and that is bug 134920.
XLSX files should be kept proper, though and they normally are.
There is a possibility of short-hand version of range address in file (sqref="10:131" instead of sqref="A10:XFD131"), that is read by MSO. 
Sample is attached.
LO opens it but saves wrongly. There is https://gerrit.libreoffice.org/c/core/+/166269 for that. 

This ticket is about applying the OOXML Standard that says that child attributes name and sqref of protectedRange are required. 
Without it, MSO says that XLSX is corrupted, and LO should also do it.
That would safeguard XLSX in saving, so that potential wrong save is seen on next fileopen.