[Solved] How to set up default search options?

Discuss the spreadsheet application
Post Reply
xuzo
Posts: 7
Joined: Sun Apr 14, 2019 4:08 am

[Solved] How to set up default search options?

Post by xuzo »

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
Tagged ✓ [Solved]
Tagged ✓ [Solved]
Windows 10, 64 Bit
Open Office 4.1.6
User avatar
MrProgrammer
Moderator
Posts: 4883
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: How to set up default search options?

Post by MrProgrammer »

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, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply