[Libreoffice-bugs] [Bug 122921] New: EDITING XLSX The sheet protection allows different options in Calc and Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

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