Bug 81442 - EDITING: When doing a Search and Replace All, "Current selection only" becomes deselected.
Summary: EDITING: When doing a Search and Replace All, "Current selection only" become...
Status: RESOLVED DUPLICATE of bug 132031
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
Whiteboard: BSA
: 113813 (view as bug list)
Depends on:
Blocks: Find&Replace-Dialog
  Show dependency treegraph
Reported: 2014-07-16 21:02 UTC by Nick
Modified: 2023-11-29 01:30 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

screenshot of setup (207.54 KB, image/png)
2014-07-16 21:02 UTC, Nick
Test case (16.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-07-17 18:56 UTC, Nick
Video Example (2.69 MB, video/quicktime)
2014-07-17 19:06 UTC, Nick

Note You need to log in before you can comment on or make changes to this bug.
Description Nick 2014-07-16 21:02:46 UTC
Created attachment 102942 [details]
screenshot of setup

Problem description: 
When doing a Search and Replace All, with Regular expressions and Current selection only selected, after Replace All, Current selection is deselected

Steps to reproduce:
1. Select column of text with valid entries
2. Select Find and Replace
3. Put in a regex: ([0-9]+) replacing with $1;GPS.
4. Select Regular expressions and Current selection only
5. Search and replace

Current behavior: (Sometimes) after replace happens and I select the next column to do the operation on, the "Current selection only" becomes deselected. So the whole document starts replacing any number string (which can crash Calc).

Expected behavior: Maintain selected preferences in Find and Replace

Notes: Not consistent behavior. Sometimes it works and other times not. Try is several times first?

Operating System: Mac OS X
Version: release
Comment 1 tommy27 2014-07-17 18:44:40 UTC
(In reply to comment #0)
> ....
> Notes: Not consistent behavior. Sometimes it works and other times not. Try
> is several times first?

reproduced one time with LibO under Win7x64
not reproducible in a consistent way like you said

please upload a test spreadsheet file so other may easily test
Comment 2 Nick 2014-07-17 18:56:28 UTC
Created attachment 102997 [details]
Test case
Comment 3 Nick 2014-07-17 19:06:17 UTC
Created attachment 102998 [details]
Video Example

So the Current selection becomes deselected when making new selections, not doing the find and replace. So to reproduce the issue, just make Current selection be selected, then select different areas of the document.
Comment 4 ign_christian 2014-07-18 06:35:10 UTC
I got consistent behavior with this simple steps:
1. Open attached file
2. Select any cell ranges
3. Find and Replace (ctrl-H)
4. Click 'Other Options' and verify that "Current selection only" ticked
5. Select any cell ranges outside previous selection

Reproduced with LO,,, - Ubuntu 12.04 x86

AOO 3.4.1 and 4.1.0 doesn't select "Current selection only" by default, but the check box greyed out with above steps. So this behavior likely inherited from OOO.
Comment 5 QA Administrators 2016-09-20 09:31:59 UTC Comment hidden (obsolete)
Comment 6 Buovjaga 2017-11-16 10:53:12 UTC
*** Bug 113813 has been marked as a duplicate of this bug. ***
Comment 7 Xisco Faulí 2019-05-16 10:48:15 UTC
Still reproducible in

Build ID: f897342320ad3a29cf4be1437c8e3ce888bdb3cb
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 8 Safeer Pasha 2021-03-01 08:12:57 UTC
i could NOT ENCOUNTER the bug after several tries. 
everything works as expected. I did my tests in the file "Test Case" provided by Nick in the Attachments. 

Version: / LibreOffice Community
Build ID: 10(Build:3)
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 9 QA Administrators 2023-03-02 03:25:18 UTC Comment hidden (obsolete)
Comment 10 ady 2023-05-17 13:03:27 UTC
FWIW, as of 7.6.alpha, the "Current selection only" checkbox keeps the check-mark when changing the selection, _if_ the new selection is still "relevant".

For instance, using attachment 102997 [details] from comment 2:

1. Select column B
2. [CTRL]+[H]
3. Select column C > check-mark still ON.
4. Select cell A1 > check-mark still ON.
5. Select column D, which is empty > check-mark is now OFF.
6. Select column A > check-mark still OFF.

The checkbox is automatically set OFF when the highlighted area has no content.

Someone could claim that when re-selecting a "possibly-relevant" area, then perhaps the check-mark should automatically turn ON again. But for that, a series of conditions would need to be true, and I'm not sure every possible condition or context would be predictable (or IOW, to predict what the user is about to do and what its real intention).
Comment 11 m_a_riosv 2023-11-29 01:30:19 UTC
Unifying in one bug.

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