[Solved] How to set up default search options?

Discuss the spreadsheet application

[Solved] How to set up default search options?

Postby xuzo » Wed Jan 22, 2020 10:51 am

Search window triggers search in formulas by default...not very helpful!

HOw can I set it up to search by values and other settings by default?
Attachments
2020-01-22 15_46_55-FindReplaceTest.ods - OpenOffice Calc.png
Tagged ✓ [Solved]
Windows 10, 64 Bit
Open Office 4.1.6
xuzo
 
Posts: 5
Joined: Sun Apr 14, 2019 4:08 am

Re: How to set up default search options?

Postby MrProgrammer » Wed Jan 22, 2020 8:27 pm

xuzo wrote:How can I set it up to search by values and other settings by default?
OpenOffice Calc does not provide a way to set defaults for Edit → Find&Replace, however my AOO 4.1.7 version remembers the settings from the previous Find&Replace operation. Once you set Search In to Values, you won't have to change set it for later searches. I generally perform a search using shortcut ⌘F ⌘O on my Mac (use Ctrl+F Ctrl+O on other platforms) to open the dialog and show the More Options fields so I can verify the settings.

Anticipated question: "Can I make Find&Replace show More Options by default?". Answer: No. Issue 87032 - Find/Replace "in selected" usability proposal

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3964
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: eleanorb and 7 guests