[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com |.freedesktop.org| Keywords|needsUXEval | --- Comment #11 from Heiko Tietze --- (In reply to Eike Rathke from comment #10) > So, removing the protected state only if > a) the sheet is protected, and > b) the target cell is unprotected > looks sensible to me. Great, let's do it then. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Eike Rathke changed: What|Removed |Added Status|NEEDINFO|NEW -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 --- Comment #10 from Eike Rathke --- At first sight sounds reasonable. But then again, if a protected cell is copied to (or within) a temporarily unprotected sheet and that sheet then is protected again, isn't the cell expected to be protected? I guess whatever we do it will be odd for some users in some cases. So, removing the protected state only if a) the sheet is protected, and b) the target cell is unprotected looks sensible to me. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 --- Comment #8 from Heiko Tietze --- (In reply to jasonkres from comment #7) > FYI, here's the actual case that led to this... So you expect the protection flag to not get copied when I paste into unprotected cells. Sounds reasonable but OTOH users might expect the number itself to be protected. What do you think, Eike? -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 --- Comment #7 from jasonkres --- FYI, here's the actual case that led to this: 1. User is working on a sheet that is protected. 2. User sees a value in a protected cell that they would like to "reuse" in an unprotected cell -- including formatting, perhaps with some minor additional edits to the data. 3. So they Copy the protected cell and Paste it to an unprotected cell. At this point, the paste succeeds and it looks good onscreen. 4. But the user then finds unexpectedly that they cannot further edit (or even Delete) the destination because it has switched to be a protected cell. (Their option at this point is to Undo.) The reason it is unexpected from the user's point of view is that they think the cell is one that are supposed to be allowed to edit, and they are surprised that they were able to alter protection of the cell from unprotected to protected even though the sheet is currently "locked". -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com --- Comment #6 from Heiko Tietze --- (In reply to Oliver Brinzing from comment #5) > ...the way excel does it in case of copy and paste protected cells > into an unprotected area (while the sheet is protected) is much more > intuitiv, So the request changes to become more Excel-like? Sounds like a safety issue but please elaborate a bit. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 --- Comment #5 from Oliver Brinzing --- (In reply to Heiko Tietze from comment #4) > You set cell protection first via Edit > Cell Protection (applied to > selection, on by default) and enable it subsequently per Tools > Protect > Sheet... Admittedly a bit weird but the function itself is working well. i know, but the way excel does it in case of copy and paste protected cells into an unprotected area (while the sheet is protected) is much more intuitiv, cause the user is able to edit the copied range later. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Heiko Tietze changed: What|Removed |Added Status|NEW |NEEDINFO CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #4 from Heiko Tietze --- You set cell protection first via Edit > Cell Protection (applied to selection, on by default) and enable it subsequently per Tools > Protect Sheet... Admittedly a bit weird but the function itself is working well. Learn more at https://help.libreoffice.org/6.2/en-US/text/scalc/guide/cell_protect.html?DbPAR=CALC#bm_id3146119 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
