https://bugs.documentfoundation.org/show_bug.cgi?id=160779
Bug ID: 160779
Summary: Fileopen XLSX: protectedRange without name and sqref
is invalid
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ti...@libreoffice.org
CC: aron.bu...@gmail.com
Created attachment 193800
--> https://bugs.documentfoundation.org/attachment.cgi?id=193800&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
