Bug Hunting Session
Bug 98270 - Add 'Search in all sheets' option to Find toolbar
Summary: Add 'Search in all sheets' option to Find toolbar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2016-02-29 12:11 UTC by allcoms
Modified: 2016-10-01 09:54 UTC (History)
3 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 allcoms 2016-02-29 12:11:04 UTC
I am normally working with spreadsheets that contain more than one sheet so when I'm searching within a spreadsheet using Calc the standard search dialogue (CTRL+F) is insufficient so I have to:

* Hit Ctrl+H to open Find + Replace
* Click on the 'Other options' drop-down
* Tick 'Search in all sheets'
* Then I can search for the string I'm looking for

That seems like too long a procedure for such a common task so I would like to see 'Search in all sheets' added as an option to the regular search dialogue options (alongside the existing 'Find all', 'Match case' and 'Search Formatted Display String' options) and preferably enable by default too.

Thanks!
Comment 1 Joel Madero 2016-03-02 20:28:56 UTC
Requesting UX input.
Comment 2 Yousuf Philips (jay) (retired) 2016-03-02 22:43:33 UTC
Definitely a valid enhancement to the user experience.
Comment 3 GerardF 2016-03-03 08:47:08 UTC
IMHO, all options should be displayed in the main Ctrl+H dialog in the first shot without this "more options" hide/show button.
Comment 4 Yousuf Philips (jay) (retired) 2016-03-03 19:51:43 UTC
(In reply to GerardF from comment #3)
> IMHO, all options should be displayed in the main Ctrl+H dialog in the first
> shot without this "more options" hide/show button.

The more advanced features (e.g. regular expression) and features not commonly changed (e.g. search direction) should be hidden by default from the novice user. Just the same way that we hide more advanced features in the Options dialog in the Expert Configuration dialog.
Comment 5 GerardF 2016-03-03 20:16:47 UTC
(In reply to Yousuf (Jay) Philips from comment #4)

> The more advanced features (e.g. regular expression) and features not
> commonly changed (e.g. search direction) should be hidden by default from
> the novice user.

Most of these options (may be all) are remembered, so I need to click on "more options" each time I hit Ctrl+H to check what options were use last time and still in use.

It is near impossible to use Find & Replace without opening the option dialog.
Comment 6 GerardF 2016-03-03 20:23:14 UTC
See this discussion (about OpenOffice) in the forum :
https://forum.openoffice.org/en/forum/viewtopic.php?f=106&t=80312

I'm not the only one.

"Eliminate More Options in this dialog. I always have to expand the dialog since it is easy to forget which options might have been preserved from a previous Find & Replace"
Comment 7 Yousuf Philips (jay) (retired) 2016-03-03 21:19:44 UTC
(In reply to GerardF from comment #6)
> See this discussion (about OpenOffice) in the forum :
> https://forum.openoffice.org/en/forum/viewtopic.php?f=106&t=80312
> 
> I'm not the only one.

Then the correct approach would be that the dialog should remember the state of all options and whether the 'More Options' was open or not.
Comment 8 pbraconnot 2016-03-19 01:57:17 UTC
My first comment here because this bug really is annoying, sorry folks!
Calc is not aimed to beginners anyway, so after years using it that's my list of features for searching in Calc:


1- The "More options" button should be removed
2- Search in all sheets should be default for all searches.
3- Easy search to have a checkbox to limit search to one sheet globally saved

Maybe the best way is to put all these options in the preferences panel so the "More options" options would be saved globally. 

Today advanced search falls back to one sheet after quit/reopen the program, so it's really easy to forget your options. If Libreoffice was open before then you already changed the options, but if not, you have to change it again.
Comment 9 Yousuf Philips (jay) (retired) 2016-03-19 14:53:37 UTC
(In reply to pbraconnot from comment #8)
> Calc is not aimed to beginners anyway, so after years using it that's my
> list of features for searching in Calc:

Calc is aimed at whomever wants to use a spreadsheet app, beginner or advanced user, just like any of the other apps in LibreOffice.

> 1- The "More options" button should be removed

Cant say that i agree with this, as showing all the options would make the dialog too large.

> 2- Search in all sheets should be default for all searches.

Likely a good default both in the toolbar and dialog.

> 3- Easy search to have a checkbox to limit search to one sheet globally saved

Yes if it could be made globally saved, that would likely be a good option.

> Maybe the best way is to put all these options in the preferences panel so
> the "More options" options would be saved globally. 
> 
> Today advanced search falls back to one sheet after quit/reopen the program,
> so it's really easy to forget your options. If Libreoffice was open before
> then you already changed the options, but if not, you have to change it
> again.

I'd suggest you submit these suggestions as a new enhancement bug report, as we only tackle one issue per bug.
Comment 10 Timur 2016-04-26 18:03:06 UTC
Bug 98539 has "All sheets" fixed in compact Find & Replace dialog for LO 5.2. 
"Other options" state should be in Bug 98544.
Comment 11 Cor Nouws 2016-09-25 19:22:40 UTC
(In reply to Timur from comment #10)
> Bug 98539 has "All sheets" fixed in compact Find & Replace dialog for LO
> 5.2.

An improvement indeed.
 
> "Other options" state should be in Bug 98544.

And then still there are more discussion about the behavior.