[Libreoffice-bugs] [Bug 108017] New: XLSB: sheet protection is reversed

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: jluth at mail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170523/b3defca2/attachment.html>