Bug 158425 - About which cells remain selected after replacing
Summary: About which cells remain selected after replacing
Status: RESOLVED DUPLICATE of bug 132031
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.3.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-28 22:23 UTC by J22Gim
Modified: 2023-11-29 01:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description J22Gim 2023-11-28 22:23:42 UTC
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!
Comment 1 m_a_riosv 2023-11-29 01:32:23 UTC

*** This bug has been marked as a duplicate of bug 132031 ***