Description: I have a column of cells that contain various text. I want to do a number of 'Replace all' commands on the whole column - e.g. replace "&" with "and", then replace " " with "", etc.. When I do the first 'Replace All' the selection is changed from the whole column to just the cells where the first text was replaced. I then have to re-select the whole column again. It would be good to have an option to keep the original selection. Instead of doing "Find All" then "Replace All", this option would work as if the user was pressing 'Replace' until there was no text left to replace - doing this leaves the selection the same. Steps to Reproduce: 1. create a column of cells with various text and select the column 2. do a 'Replace all' of text that only affects so cells Actual Results: Only the cells with replaced cells are now selected Expected Results: the whole column originally selected should remain selected. Reproducible: Always User Profile Reset: No Additional Info: With the new option, the whole column originally selected would remain selected.
I don't agree, because how it works now allow doing other treatment, like change any property of those finding and selected cells or a subsequent substitution in the content. And it is the only way to do such deep selection.
(In reply to m.a.riosv from comment #1) > I don't agree, because how it works now allow doing other treatment, like > change any property of those finding and selected cells or a subsequent > substitution in the content. And it is the only way to do such deep > selection. Thanks for the comment. I'm not suggesting that the current method is changed. I'm asking for an EXTRA option to be added (maybe as a 'tick box' on the 'Find and Replace' dialogue box) that keeps the original selection after doing 'Replace all'.
+1 for an extra option "[x] Keep current selection"
I support this as an additional option. I was just running into this a few days ago where I was wanting to do two Replace Alls on the same column, and before doing the second, I had to select all the cells of the column again. That seems a waste of time. If I could have a way for it to maintain the full selection, I can see that saving me time across my many uses of Calc.
*** Bug 145691 has been marked as a duplicate of this bug. ***
Duplicate of bug 132031, discussed recently in bug 141296 *** This bug has been marked as a duplicate of bug 132031 ***