https://bugs.documentfoundation.org/show_bug.cgi?id=154466
Bug ID: 154466 Summary: Overwriting data warnings should be an undo notice, not confirm dialog (UX) Product: LibreOffice Version: 7.4.5.1 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: explore...@gmail.com Created attachment 186311 --> https://bugs.documentfoundation.org/attachment.cgi?id=186311&action=edit overwrite warning UI suggestion (popup notification) Steps to reproduce: 1. "Tools" -> "Options" 2. "LibreOffice Calc" -> "General", enable "Show overwrite warning when pasting data" checkbox 3. Open an empty spreadsheet in LibreOffice Calc 4. Fill in cells A1 and A2 with content (texts "A1" and "A2" respectively) 5. Select A1 cell; press Ctrl+C (copy) 6. Select A2 cell; press Ctrl+V (paste) Actual result: A confirmation dialog saying "You are pasting data into cells that already contain data" with responses "Yes" and "No". Expected result: Cell A2 gets overwritten right away, but a non-disruptive popup appears in a corner, showing how many cells with existing data get overwritten, with a hint that the user may undo if they didn't mean to overwrite data. (See attached picture for UI example.) Explanation of the issue: This article explains well why a _confirmation_ warning is bad when the action is undo-able: "Never Use a Warning When you Mean Undo" https://alistapart.com/article/neveruseawarning/ (A confirmation warning is okay when the action is really not undo-able. For example overwriting an existing file in the Save As dialog. But it's not the case for overwriting cells here.) I know why the warning existed - to prevent users from accidentally overwriting data. But implementing the warning in a _confirmation_ dialog disrupts the user's workflow more than the warning itself benefits. Since there are already UIs in the wild that implement this right, LibreOffice should do the same. Also, remove the "Show overwrite warning when pasting data" checkbox from the Options. When overwriting data cells becomes a non-disruptive notification, it makes no sense for users to opt out the warning. Related (but not the same bug): Bug 87607 -- You are receiving this mail because: You are the assignee for the bug.