https://bugs.documentfoundation.org/show_bug.cgi?id=108017
Bug ID: 108017
Summary: XLSB: sheet protection is reversed
Product: LibreOffice
Version: 4.3.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 133466
--> https://bugs.documentfoundation.org/attachment.cgi?id=133466&action=edit
protectedSheet.xlsb: binary format reverses protection settings.
This .xlsb file was created with sheet protection enabled. Everything is
disallowed, EXCEPT for allowing the selection of unlocked cells. It works fine
in .xlsx format, but in .xlsb the entire sheet is selection-locked EXCEPT for
the locked cells. In other words, the protection works backwards for .xlsb
compared to .xlsx.
broken in LO4.3 development by author Noel Power 2013-11-21 18:12:50
commit 5728a56b20e01d6c9e86a23f20af64a1b68ad604
fdo#70499 selectn of lock/unlocked cells with worksheet protection reversed
https://cgit.freedesktop.org/libreoffice/core/commit/?id=5728a56b20e01d6c9e86a23f20af64a1b68ad604
Steps to reproduce.
1.) Open protectedSheet.xlsb. Try clicking in a white (unlocked) cell.
2.) Notice that you CAN'T select any of these cells.
3.) click on one of the blue cells (A1:B2) which are locked.
4.) Notice that you CAN select these cells.
5.) Disable tools-Protect Sheet, and then re-enable it again to see the dialog.
6.) Notice that the user can do everything except select unprotected cells.
That is the opposite of what happens in MSO (and the opposite of what happens
when reading the .xlsx/.xlsm form of the file).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
