I am doing a lot of questionnaire pre-processing in LibreOffice. Some of it involves selecting some *specific* data columns and then doing successive find and replace operations on the exact same select area (an example is at the end of this enhancement request). If one does a F/R operation on a selected area ('Current Selection Only'), the selected area is subsequently changed to be only those cells that were affected by the operation. I'd be grateful if you would consider adding an option of some sort in the F/R dialog that becomes active when "Current Selection Only" is selected, that "locks" the selected area to be the same, even after the replace takes place (don't have a good name for that). =================================== AN EXAMPLE CASE: Some columns contain data like either 'a', or 'b' or 'c' and one has to "rotate" these data in the cells. That is, 'b' cells in the selection stay as they are, whereas 'a' become 'c' and 'c' become 'a'. To accomplish that, I'd be doing a F/R on the selected columns of 'a' to 'x' (a helper dummy), then 'c' to 'a' and finally 'x' to 'c'.
Thank you for reporting this request. I have changed the severity of the bug report to reflect that this is an enhancement.
(In reply to Michail Pappas from comment #0) > AN EXAMPLE CASE: Some columns contain data like either 'a', or 'b' or 'c' > and one has to "rotate" these data in the cells. This example is about a swap function, like discussed here https://ask.libreoffice.org/en/question/216078/macro-to-swap-cell-contents/. I understand "keep the selection" as A1:A10 is selected, you do F&R, and expect A1:A10 still being selected. In fact the selection is changed to what has been modified. It's a very handy function when you just want to find something and also needed in case the replace dialog is not shown. So we would need an option that is off by default. Eike, what do you think?
Dear Michail Pappas, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Not sure of what I should provide here, apart from keeping this enhancement request open. I'll just switch it to UNCONFIRMED as per the instructions given. (In reply to QA Administrators from comment #3) > Dear Michail Pappas, > > This bug has been in NEEDINFO status with no change for at least > 6 months. Please provide the requested information as soon as > possible and mark the bug as UNCONFIRMED. Due to regular bug > tracker maintenance, if the bug is still in NEEDINFO status with > no change in 30 days the QA team will close the bug as INSUFFICIENTDATA > due to lack of needed information. > > For more information about our NEEDINFO policy please read the > wiki located here: > https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO > > If you have already provided the requested information, please > mark the bug as UNCONFIRMED so that the QA team knows that the > bug is ready to be confirmed. > > Thank you for helping us make LibreOffice even better for everyone! > > Warm Regards, > QA Team > > MassPing-NeedInfo-Ping
Me set NEEDINFO for Eike's opinion. Anyway, I agree with the request.
*** Bug 145691 has been marked as a duplicate of this bug. ***
*** Bug 143500 has been marked as a duplicate of this bug. ***
*** Bug 141296 has been marked as a duplicate of this bug. ***
*** Bug 81442 has been marked as a duplicate of this bug. ***
*** Bug 139886 has been marked as a duplicate of this bug. ***
*** Bug 158425 has been marked as a duplicate of this bug. ***
Another vote to support this option, and another scenario that would make this option an enormous improvement. In my case in a sheet with 40k+ rows, I am selecting and working on a noncontiguous subset of cells that I want to perform replacements on without affecting the non selected cells. Reselecting this custom selection of cells for every rename operation is arduous to say the least, which is what led me here. It could be added as an additional setting in the "Other options" section of the F/R window. Maybe "Sticky replacement selection"? Thanks for your consideration.