<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - XLSB: sheet protection is reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108017">108017</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLSB: sheet protection is reversed
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jluth@mail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133466" name="attach_133466" title="protectedSheet.xlsb: binary format reverses protection settings.">attachment 133466</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133466&action=edit" title="protectedSheet.xlsb: binary format reverses protection settings.">[details]</a></span>
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
<a href="https://cgit.freedesktop.org/libreoffice/core/commit/?id=5728a56b20e01d6c9e86a23f20af64a1b68ad604">https://cgit.freedesktop.org/libreoffice/core/commit/?id=5728a56b20e01d6c9e86a23f20af64a1b68ad604</a>
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).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>