[Libreoffice-bugs] [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 #16 from Timur --- *** Bug 150910 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Timur changed: What|Removed |Added CC||iavs.le...@gmail.com --- Comment #15 from Timur --- *** Bug 150910 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [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 #14 from Eike Rathke --- Note that this bug and bug 150910 somewhat contradict each other in expectations. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [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 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||6965 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [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 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||3349 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 LeroyG changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0910 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Timur changed: What|Removed |Added Blocks||107450 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107450 [Bug 107450] [META] Cell and sheet protection bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 m.a.riosv changed: What|Removed |Added CC||nunomvar...@gmail.com --- Comment #13 from m.a.riosv --- *** Bug 132829 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 #12 from Oliver Brinzing --- (In reply to Heiko Tietze from comment #11) > (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. +1 as long as it only works with ui copy & paste. IMO the copyRange() API method should not change cell attributes. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 #3 from Oliver Brinzing --- Created attachment 149858 --> https://bugs.documentfoundation.org/attachment.cgi?id=149858=edit demo copy cell protected sheet (xlsx) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [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 #2 from Oliver Brinzing --- Created attachment 149857 --> https://bugs.documentfoundation.org/attachment.cgi?id=149857=edit demo copy cell protected_sheet -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123974] Paste into a protected Calc sheet should not paste the cell Protected status
https://bugs.documentfoundation.org/show_bug.cgi?id=123974 Oliver Brinzing changed: What|Removed |Added Keywords||needsUXEval Ever confirmed|0 |1 Status|UNCONFIRMED |NEW CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- (In reply to jasonkres from comment #0) > 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. i can confirm this behaviour current workaround: use paste special > 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. this seems to be the same as ms excel 2016 does. makes sense for me. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
