Description: After replacing the content of a number of cells using 'Find & Replace' dialog, the cells that changed are kept selected. Why? It doesn't make a lot of sense to me. It would be ideal that the after-task selection respects the range originally selected by the user. I explain below why this suggested behavior is much more useful than the current one. Steps to Reproduce: 1. Imagine you have a 'Sports' column populated with values, for example, sports names. So you have MANY occurrences of the words 'soccer', 'handball', 'basket', 'volley' 2. Now you want to replace several of them: 'soccer' to 'football', 'basket' to 'basketball', 'volley' to 'volleyball' 3. SELECT THE ENTIRE 'Sports' COLUMN 4. Open the Find & Replace dialog and start. You write 'soccer' in Find and 'football' in Replace. Press Enter and the replacement is done but ... Actual Results: Now ONLY THOSE CELLS THAT WERE JUST REPLACED ARE SELECTED. This is, Calc changed the selection set by the user in the first place, to only select the cells containing 'football'. The problem is that, if you now want to continue with your objective ('basket' to 'basketball'), before the next replacement you have to select the 'Sports' column again. And repeat as many times as replacements you need. Expected Results: It would be more sensible to keep the user-selected range at all times. This way a) one could make multiple replacements without leaving the Find & Replace dialog b) the selection does not change in an unexpected (to me anyway) fashion Reproducible: Always User Profile Reset: No Additional Info: But maybe there is a good reason and I am missing it!
*** This bug has been marked as a duplicate of bug 132031 ***