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.
Requesting UX input.
Definitely a valid enhancement to the user experience.
IMHO, all options should be displayed in the main Ctrl+H dialog in the first shot without this "more options" hide/show button.
(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.
(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.
See this discussion (about OpenOffice) in the forum :
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"
(In reply to GerardF from comment #6)
> See this discussion (about OpenOffice) in the forum :
> 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.
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.
(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
I'd suggest you submit these suggestions as a new enhancement bug report, as we only tackle one issue per bug.
Bug 98539 has "All sheets" fixed in compact Find & Replace dialog for LO 5.2.
"Other options" state should be in Bug 98544.
(In reply to Timur from comment #10)
> Bug 98539 has "All sheets" fixed in compact Find & Replace dialog for LO
An improvement indeed.
> "Other options" state should be in Bug 98544.
And then still there are more discussion about the behavior.
Now in 7.0.1 it's easier with Ctrl+H. Just a tickbox and done.
I don't consider this option need to be in Find Toolbar.
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Created attachment 165713 [details]
see this image
*** Bug 149912 has been marked as a duplicate of this bug. ***
Since the UX input was requested at the duplicate ticket let's discuss here.
I'm against "[ ] All Sheets" because a) it adds complexity to the simple quick find toolbar, and b) showing results across different sheets is confusing. But no strong objection.
>>Heiko wrote: I assume Find Next jumps to the first occurrence at the next
Yes, that's exactly how it should work!
As an answer from here:
We discussed this topic in the design meeting.
Automatically switching is bad, so we would have to either ask "Do you want to continue on the next sheet" or have an option. The checkbox option clutters the simple quick find bar (maybe not itself but we try by all means to keep this toolbar simple). And the question interrupts the workflow and calls for a "Do not show again" option.
Since it also somehow mixes the behavior and running a) a full search per Find & Replace is simple and b) a macro could do the trick of searching within all sheets we concluded to not implement this enhancement.