I would like to have the ability to disable "Search Results" when performing a Replace-All in Calc. This would return it to the pre-LibreOffice 4.2.x implementation.
In LibreOffice 4.2.X, Calc implemented showing the “Search Results” dialog for Find-All and Replace-All functions. It now pops up a dialog with a list of all cells that were found and/or modified.
I do like the “Search Results” window and think it is quite useful for Find-All, since you actually are looking for results in that function. Unfortunately, dismissing this dialog adds an extra step to my workflow and hampers productivity when performing many Replacements. Even with Replacements, I can see how it might appear helpful to have a list of all things that have been replaced, but its utility simply isn't worth the inefficiency.
I think it would be a good option to include in the “Other Options” section of the Find and Replace dialog, as long as the setting is sticky. If not there, I don't know where it should live. It could possibly even live under the expert config page, as long as I have a way of setting it.
Also, I'm aware that Writer and other components pop-up a similar dialog showing how many items were replaced, which makes them just as inefficient. But Calc is used much more frequently for heavy data manipulation, typically involving lots of replacements.
Really bad new feature if several thousands of records should be replaced. Libreoffice usually crashes or it takes endless time to complete the operation. I guess this search results window is the reason.
Valid also for 4.2.6
That is a bug. No one asked for that 'feature', so it should be turned OFF by default.
I concur that this is a very painful 'feature'.
When am I trying to 'Replace All' with the 'Current selection only' option, the 'Search Results' dialog box appears. Not only does this display a dialog box that obscures the spreadsheet which I have to move (as closing it just reopens it after the next 'Replace All' function), it unselects the previously selected columns forcing me to constantly reselect them before every 'Replace All' call.
In this particular case I have about 60 'Replace All' operations to run against two of seven columns in this spreadsheet. This bug means that I am forced to:
Select the two columns
Enter the Search and Replace strings
Check the 'Entire cells' and 'Current selection only' check boxes
Move the useless 'Search Results' dialog box
Update Search and Replace strings
Update Search and Replace strings
Previously all I needed to do was update the Search and Replace strings and keep pressing 'Replace All'.
Perhaps this is an inadvertent result of fixing this:
Bug 79011 - EDITING: find all/replace all, results window does not open
A simple check box option in the "Find & Replace" dialog box to show 'Search Results' with the default option set under the Preferences should take care if this issue.
(In reply to rik from comment #4)
> When am I trying to 'Replace All' with the 'Current selection only' option,
> the 'Search Results' dialog box appears. Not only does this display a
> dialog box that obscures the spreadsheet which I have to move (as closing it
> just reopens it after the next 'Replace All' function), it unselects the
> previously selected columns forcing me to constantly reselect them before
> every 'Replace All' call.
> Previously all I needed to do was update the Search and Replace strings and
> keep pressing 'Replace All'.
While I think it'd be very helpful if LibreOffice retained the original selection after a Replace All, I don't believe it ever behaved that way. I tested this with OpenOffice 3.2.1 and LibreOffice 22.214.171.124 and both of those versions also lost the original selection after performing a "Replace All" call. I think it'd be a worthy enhancement request, but I don't believe it's related to this bug.
> A simple check box option in the "Find & Replace" dialog box to show 'Search
> Results' with the default option set under the Preferences should take care
> if this issue.
I think a check box would be the most elegant solution.
While I would still like to have the option to disable Search Results while using Replace All, I did find an easy work-around for handling multiple Replace All operations. Instead of dismissing the Search Results window each time, just leave it to the side. From that point on, the Find & Replace dialog won't lose focus and seems to behave as it used to.
If you really don't want to deal with it, you can minimize the Search Results window. After that, the Search Results will never show up again. In fact, it can be very difficult to get the results dialog to show up again. It doesn't show up in my KDE taskbar, but I can bring it up by alt-tab'ing until it's selected.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT:
- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
This bug still affects 126.96.36.199.
I think this is valid as an enhancement request.
Maybe even easyHack little more interesting..?
Can't disable, but for 5.2.4 search/replace will not show more that 1000 results to resolve bug 92160
Thank you for good news! I got feeling that in 5.1.x and 5.2.x up to now, the dialogue is not showing results for certain range, but when it goes for some 10 thousands, it tries to show the result window.
I can only replace up to about 10000 records, when it is more LO crashes during the operation. When I'll have more time, I'll try to find limiting number.
looking at the useful comments / pointers in bug 104849, lets close this one as duplicate..
*** This bug has been marked as a duplicate of bug 104849 ***