<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 - EDITING XLSX The sheet protection allows different options in Calc and Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122921">122921</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING XLSX The sheet protection allows different options in Calc and Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.2 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>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<pre>Description:
The sheet protection allows different options in Calc and Excel.
Steps to Reproduce:
1. Create a new spreadsheet in Microsoft Excel 2010.
2. On the Review tab, click Protect Sheet.
3. In the Allow all users of this worksheet to list, select the Select
locked cells and Select unlocked cells elements.
4. Press OK button.
5. Save the file as XLSX.
6. Open the same file in Calc.
7. Compare the original file opened in Excel and Calc.
Actual Results:
LibreOffice Calc: We can use AutoFilter and Privot table. In unprotected cells
we can format cells, insert images, insert comments, insert hyperlinks, sort
data.
Microsoft Excel: We cannot use this options.
Expected Results:
The sheet protection should allow same options in Calc and Excel.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>