https://bugs.documentfoundation.org/show_bug.cgi?id=170865
--- Comment #9 from Sven Puschmann <[email protected]> --- I consulted professional advice in Cooper's book "About Face 3" (chapter 25) and it is quite clear about it: Users will routinely confirm confirmation dialogues and therefore they are useless. Instead do all of this: - Do, don't ask - remove the confirmation dialogue - Make all actions reversible - provide Undo and Redo as a safety net just like the Recycle bin. - provide *modeless* feedback to help users avoid mistake. In our case I would say: 1. As long as references get demonstrably broken: fix this issue, if we can. Also mind external references from other sheets (if we can detect them, because they are stored in the file). 2. Provide global Undo/Redo (menu item, toolbar buttons, keyboard shortcuts like Ctrl+Z/Ctrl+Y (Cmd+Z/Cmd+Shift+Z on macOS) that also reverses the sheet deletion and reference update. 3. Immediately after “Delete sheet”: Show an info bar under the toolbar with the message “Worksheet ‘Budget 2026’ was deleted.” and a primary “Undo” action. Provide the affected references, especially if they are broken. Include hyperlinks to the references or a "Details..." hyperlink. 4. As some cautious users might currently rely on a confirmation dialogue: introduce step 2 in the next major release and for time being tell users about the upcoming change. This gives users trust, a clear, visible, but non-blocking feedback element plus a well-known Undo mechanism for power users. 5. Find other related use cases in LO's UI and solve them consistently like this. I also checked back with MS Excel 16.107.2 (26032211) on macOS: It just deletes the sheet with no confirmation, if - there are no references to it or - it is the last sheet in the file. I think the solution shown above is smarter. To handle the edge case of the last sheet in the file: We already handle this in the Sheet tab context menu by hiding the "Delete sheet..." item. This could be improved: remove the ellipsis, because there is no following confirmation dialog; instead of hiding the menu item disable it to give a visual hint. Transparency note: Steps 2 and 3 in my advice were generated by Perplexity AI and curated by me. -- You are receiving this mail because: You are the assignee for the bug.
