https://bugs.documentfoundation.org/show_bug.cgi?id=122921
Bug ID: 122921
Summary: EDITING XLSX The sheet protection allows different
options in Calc and Excel
Product: LibreOffice
Version: 6.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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:
--
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
