Settings available in the Find&Replace dialogue under 'Other options' are reset to default values every time Calc is restarted. Selection of default values is questionable e.g. searching in formulae (default) is more useful to a developer, ordinary user would almost always prefer to search in values and might be (and frequently is) confused by Calc not finding something he can plainly see, also spreadsheet data is usually organized in a tabular form with similar items grouped in columns and so should be searched by columns, not by rows (default). Different default settings for 'Other options' are indicated, and yet many people are used to the current behaviour so changing the default settings won't be a good idea. I suggest adding configurable options for default values in 'Other options' in Find&Replace.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0 SeaMonkey/2.54a1
Let's ask UX. In general I think we want to avoid adding new options as much as possible..
(In reply to lvm from comment #0)
> Settings available in the Find&Replace dialogue under 'Other options' are
> reset to default values every time Calc is restarted.
Not seeing this. For example, using the Similarity checkbox is retained as set across sessions.
Need better STR and sample document(s) to work through this claim.
Consider the attached spreadsheet. Open it, press ^F and try to find Copenhagen - you will fail. It is there, you can see it in the A5 cell, but Calc won't find it. Very frustrating and illogical. To find it you have to:
* open Find&Replace (^H)
* click on 'Other options'
* change 'Search in' to Values
* 'Find next'
And do it every time you open Calc or used plain Find. As I said, my primary concern is the wrong choice of default values and I personally would be quite happy to see them changed without any fuss. We might need the configurable options only to make happy people who are used to the current defaults however awkward they might be.
Created attachment 136164 [details]
...and furthermore, you cannot find Copenhagen using plain Find at all because 'Other options' are available only for Find&Replace but not for Find, and Find not only ignores them but resets them to those awkward defaults every time it is used (bug 112270)
*** This bug has been marked as a duplicate of bug 102506 ***
This can't be a duplicate of tdf#102506, since the latter is about Find toolbar - which doesn't follow Find&Replace dialog settings after tdf#62601 was fixed.
(In reply to Mike Kaganski from comment #7)
> This can't be a duplicate of tdf#102506, since the latter is about Find
> toolbar - which doesn't follow Find&Replace dialog settings after tdf#62601
> was fixed.
Yes, to NEW, as indicated in comment 1 the Find & Replace (<Ctrl>+H) dialog is not persistent--and otherwise can not be configured with user set Defaults.
And while bug 62601 correctly isolated the Find bar from the Find & Replace dialog. But as noted in companion bug 112270 using the Find bar will clobber the Find dialog settings--back to defaults (just for some of the values).
But tangental issue annoying folks (comment 5 here) is that the default for the <Ctrl>+F Find bar does not search in Values, and can't be user configured to do so--that is bug 102506 with some interest in being able to restrain search to columns or to rows.
We had a couple of similar topics recently (eg. image anchoring in bugs 123169, 126247, 87720, 87742) where settings made in a dialog are expected to remain over sessions. I would take this as a rule of thumb and just save those values (without any access per Tools > Options).
(In reply to Heiko Tietze from comment #9)
> We had a couple of similar topics recently (eg. image anchoring in bugs
> 123169, 126247, 87720, 87742) where settings made in a dialog are expected
> to remain over sessions. I would take this as a rule of thumb and just save
> those values (without any access per Tools > Options).
But without an ability to reset values to known defaults--short of clearing profile--making each setting stateful would generate a whole range of usage complaints and RTFM responses to nuisance BZ reports. Seems wise to at least provide a reset if not maintaining 'defaults' on launch for the Find & Replace dialog.
So let's go with a checkbox "[x] Use options from Find & Replace". And drop the extra options "[ ] Formatted Display" and "[ ] Match Cases".