Starting in 4.2, when you use the Find & Replace dialog in Calc, a Search Results dialog appears after it has completed the replacements. This dialog shows the new value added to all the cells where the replacements are done. As cells that have been touched by the replacement are already highlighted, there isnt much use for this dialog in regular cases. Also the dialog doesnt show one of the most important things, the total number of replacements, which is present in writer's post-replacement dialog. The dialog also slow down performance, when large amounts of replacements are made in large spreadsheets (e.g. bug 79422), so it would be best not to show this dialog unless the user wishes it to be show.
+ 1 (wouldn't be surprised if there already is an issue for this ;) )
(In reply to Jay Philips from comment #0) > Starting in 4.2, when you use the Find & Replace dialog in Calc, a Search > Results dialog appears after it has completed the replacements. > > This dialog shows the new value added to all the cells where the > replacements are done. As cells that have been touched by the replacement > are already highlighted, there isnt much use for this dialog in regular > cases. Also the dialog doesnt show one of the most important things, the > total number of replacements, which is present in writer's post-replacement > dialog. The dialog also slow down performance, when large amounts of > replacements are made in large spreadsheets (e.g. bug 79422), so it would be > best not to show this dialog unless the user wishes it to be show. I actually like this Search Results dialogue box. There you can select the different replacements and the cursor jumps to this cell and then you can easily see it in the context. Therefore, if I have a larger Calc sheet it is useful for me, because I do not need to scroll manually, where I can maybe miss one. Therefore, I would like to keep it. But maybe the number of replacements could be added to this dialogue box.
I'm all for keeping it Andy, but prefer it doesnt show up by default and users having the ability to turn it on and off. :D
The normal workflow is slowed down, but there are use-cases where this dialog makes sense. So why don't add a checkbox to the F&R dialog "[ ] Show summary". This setting would be useless in case of replace step by step. The other option is to require an explicit activation for this dialog. For instance via menu item below Find & Replace like "Show last replacements (Shift+Ctrl+H)". Drawback here is that this option is available for a short period only. The last R&F result becomes invalid after user changes, and so the dialog. Last but not least we could show the search results in the R&F dialog itself, perhaps using a results tab. This dialog remains open right now until closed by user. I think this would be the best solution.
(In reply to Heiko Tietze from comment #4) > The normal workflow is slowed down, but there are use-cases where this > dialog makes sense. So why don't add a checkbox to the F&R dialog "[ ] Show > summary". This setting would be useless in case of replace step by step. I like that one. > Last but not least we could show the search results in the R&F dialog > itself, perhaps using a results tab. This dialog remains open right now > until closed by user. I think this would be the best solution. I think esp. for larger selections that may sill give some delay?
(In reply to Heiko Tietze from comment #4) > The normal workflow is slowed down, but there are use-cases where this > dialog makes sense. So why don't add a checkbox to the F&R dialog "[ ] Show > summary". This setting would be useless in case of replace step by step. Yes this is what i was suggesting. Thanks for visualizing it further. :D
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.