[Libreoffice-bugs] [Bug 132031] New: EDITING Enhancement Request: When using 'Current Selection Only' in F/R, keep the same selection after each replace operation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132031

            Bug ID: 132031
           Summary: EDITING Enhancement Request: When using 'Current
                    Selection Only' in F/R, keep the same selection after
                    each replace operation
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: painful8th at gmail.com

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'.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200410/1bd74f26/attachment.htm>