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: NEW
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: 2021-03-01 08:12 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:
Regression By:

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