[Libreoffice-bugs] [Bug 139883] New: Calc refuses to edit an unprotected cell in a protected worksheet when the selected range includes protected cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jan 24 11:44:14 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=139883

            Bug ID: 139883
           Summary: Calc refuses to edit an unprotected cell in a
                    protected worksheet when the selected range includes
                    protected cells
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: douglas.boffey at gmail.com

Description:
In a protected worksheet, if a range containing protected cells is selected,
even though the active cell is unprotected, the error, "Protected cells can not
be modified." is shown.

Steps to Reproduce:
1. Unprotect some cells
2. Select a range including both protected and unprotected cells
3. Ensure the active cell is unprotected
4. Try to edit

Actual Results:
The error diagnostic, "Protected cells can not be modified."

Expected Results:
Calc should accept the edit


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL

-- 
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/20210124/750a3afe/attachment.htm>


More information about the Libreoffice-bugs mailing list