Bug Hunting Session
Bug 112271 - Configurable default values for 'Other Settings' in Find&Replace
Summary: Configurable default values for 'Other Settings' in Find&Replace
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.1.2 release
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2017-09-07 09:47 UTC by lvm
Modified: 2019-08-12 11:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
testcase (16.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-11 08:46 UTC, lvm
Details

Note You need to log in before you can comment on or make changes to this bug.
Description lvm 2017-09-07 09:47:21 UTC
Description:
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.

Actual Results:  
see description

Expected Results:
see description


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0 SeaMonkey/2.54a1
Comment 1 Buovjaga 2017-09-10 17:57:55 UTC
Let's ask UX. In general I think we want to avoid adding new options as much as possible..
Comment 2 V Stuart Foote 2017-09-10 18:44:54 UTC
(In reply to lvm from comment #0)
> Description:
> 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.
Comment 3 lvm 2017-09-11 08:45:40 UTC
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.
Comment 4 lvm 2017-09-11 08:46:19 UTC
Created attachment 136164 [details]
testcase
Comment 5 lvm 2017-09-11 08:58:38 UTC
...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)
Comment 6 V Stuart Foote 2017-09-11 18:03:39 UTC

*** This bug has been marked as a duplicate of bug 102506 ***
Comment 7 Mike Kaganski 2019-08-10 15:10:31 UTC
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.
Comment 8 V Stuart Foote 2019-08-10 17:58:53 UTC
(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.
Comment 9 Heiko Tietze 2019-08-12 08:08:46 UTC
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).
Comment 10 V Stuart Foote 2019-08-12 11:55:20 UTC
(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.