[Libreoffice-bugs] [Bug 123974] New: Paste into a protected Calc sheet should not paste the cell Protected status

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123974
           Summary: Paste into a protected Calc sheet should not paste the
                    cell Protected status
           Product: LibreOffice
           Version: 6.2.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jason at binarycoder.net

Description:
The interaction of copy and paste with protected cells is very awkward. The
ability to copy a protected cell into a protected sheet while the sheet
protection is on is important to my users. However, it is surprising that there
is only one way to modify the pasted data after doing this -- Undo. If the user
does something unintended then saves and re-opens the file, the only way to
undo what the program let the user do is unprotect the sheet which the user may
not be allowed to do.

See Expected Results for a suggestion on how to improve this without
restricting the user.

Steps to Reproduce:
1. Create a new Calc sheet.
2. Put arbitrary data into cell A1.
3. Set cell B1 as NOT Protected through Format Cells > Cell Protection.
4. Tools > Protect Sheet with the default options.
5. Select cell A1 and copy it with Ctrl+C.
3. Select cell B1 and press Ctrl+V to paste.
5. Press Delete to attempt to clear B1.

Actual Results:
The clear of B1 using Delete (as well as by text edit, etc.) is blocked because
the protection of cell A1 was copied to B1.

Expected Results:
Suggest that when the destination sheet protection is ON, any pasted cell
should automatically be unprotected as part of the paste operation.
To see that the user has the right to do this, this is equivalent to copying
the protected cell to a new unprotected sheet, clearing the protection there,
and then using copy/paste from the new sheet to the protected sheet.

When the destination sheet protection is OFF, the current behavior to copy and
paste the protected state makes sense.



Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.1.2 (x64)
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
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/20190309/3edd5b44/attachment.html>