https://bugs.documentfoundation.org/show_bug.cgi?id=58676
--- Comment #11 from Jeff Fortin Tam <nekoh...@gmail.com> --- > a user that would execute find and replace on all sheets by mistake > (and might not even notice the 'all sheets' checkbox) > would unwillingly modify data without the possibility of recovering it. I have tested now, and Undo (Ctrl+Z) *does* work even if you did a search & replace across all sheets. That said, I can empathize with your concern. If you want the UI to be extra helpful in preventing "did not notice" accidents, what should be done instead is, in the Search & Replace results dialog (misnamed as "Search Results"...): * Instead of only showing "6 results found" as a string near the bottom, show "<b>6</b> results found and replaced across <b>3</b> sheets." (use bold text and indicate the number of sheets affected, in case the user doesn't notice from the sheet names column, especially with large lists of results) * Provide an "Undo" button directly in that dialog, next to the Close button. That way, the user cannot panic, the button is conveniently right there. * ALWAYS show that dialog when doing a search (or search & replace) across multiple sheets, and hide the "Show this dialog" toggle checkbox widget in that situation. In fact, since there is no option to turn that option back on from the "Find and Replace" dialog, I might go one step further and recommend eliminating this option entirely, it kinda makes no sense. * Bonus points: make that dialog larger to avoid scrolling (ideally auto-sized if there aren't too many results), i.e. bug #157207 -- You are receiving this mail because: You are the assignee for the bug.
