Bug 148062 - [UI] In Calc, find-and-replace dialog (Ctrl-H) doesn't remember the "Current selection only" option
Summary: [UI] In Calc, find-and-replace dialog (Ctrl-H) doesn't remember the "Current...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find&Replace-Dialog
  Show dependency treegraph
 
Reported: 2022-03-18 06:14 UTC by Toby Bartels
Modified: 2024-01-12 13:48 UTC (History)
4 users (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 Toby Bartels 2022-03-18 06:14:38 UTC
Description:
Most (all?) settings in the Ctrl-H find-and-replace dialog are preserved from search to search; in fact, I can even restart my computer and they're still there.  But the setting "Current selection only" is forgotten.

Steps to Reproduce:
1.  Select a range of nonempty cells (at least one nonempty), open find-and-replace, open "Other options", uncheck "Current selection only", and (optionally) make a search.
2.  Stop selecting a range of cells (or select only empty cells), open find-and-replace, and (optionally) make a search.
3.  Select a range of nonempty cells (at least one nonempty), open find-and-replace, and make a search.

Actual Results:
Search is only in the current selection; this option has been reset to its default.

Expected Results:
Search should be in the entire spreadsheet; the option should have been remembered.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
If you skip step 2, then it works as expected.  So the option is only forgotten if there is an intermediate stage in which the default is reversed or the option is unavailable.  (This option has a complicated default behaviour: it's on if you open the dialog while a range of cells is selected, as long at least one of the selected cells is nonempty; off if you open the dialog while no range is selected and the current cell is nonempty; and unavailable if a range of empty cells is selected, or no range is selected and the current cell is empty.  At least that's how it seems to work when I try it out.)

This bug also appears in reverse, and in a simpler way; if in step 1 you move to an nonempty cell (instead of selecting a range) and check (instead of unchecking) "Current selection only", then this choice is immediately forgotten (you can even skip step 2).  But since I don't know any use for searching only within a single cell (since you end up in that cell either way), I'm not reporting this reverse bug as a bug.  It's just strange behaviour that may be related.

Also, this is the first time that I've reported a bug here, and I had no idea how to answer the required question as to when this first appeared.  It appears in the current version, so I selected that, but it probably appeared earlier.  (It just didn't impact me earlier, because I didn't need to use Ctrl-H then.)

Version: 7.3.1.3 (x86) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2022-03-18 12:45:34 UTC

*** This bug has been marked as a duplicate of bug 113485 ***
Comment 2 Toby Bartels 2022-03-18 13:05:21 UTC
This is not a duplicate of Bug 113485.  That one is about quick find (Ctrl-F), while this one is about the find-and-replace dialog (Ctrl-H).  That one asks for Ctrl-F to behave (at least in Writer) more like how Ctrl-H already behaves (at least in Calc), and this one is about how Ctrl-H forgets when you set the option to make it behave more like Ctrl-F.  The two requests are, if anything, closer to opposites than duplicates.  (But they're not really opposites either; they could both be fulfilled with no contradiction, although that would probably be a bit odd.)
Comment 3 Andreas Heinisch 2024-01-12 13:48:08 UTC
This is actually a feature since you may select different cells every time you replace.

After a multiselection, the checkbox will be automatically checked or disabled. If you again just select a single cell, the checkbox will be unchecked automatically.

Remembering the current state will disable this feature which probably is not desired.