Options in Calc Find (CTRL+F)

[TP123]

Using LibreOffice 25.8.3.2 with Windows 10.
I have a spreadsheet with 7 tabs/worksheets.
When I am looking for something (using CTRL+F) I get a bar at the bottom of the tab/worksheet.
Calc looks for the value typed in this bar in the current tab/worksheet only.
Is there a way to:

1. Have a dialog window appear instead of the bar?
2. Have Calc look for this value in all the tabs/worksheets, not just the currently selected one?
3. Have Calc look for this value in formulas? E.g. if I have a formula that contains “dd/mm/yyyy” this will translate in 01/05/2026. However, what I would like to find is the string “dd/mm/yyyy”

[EarnestAl]

@TP123

1. Have a dialog window appear instead of the bar?

Use *Edit > Find and replace (Ctrl+H)

@TP123

2. Have Calc look for this value in all the tabs/worksheets, not just the currently selected one?

Select all the tabs in which you want search. You can Ctrl+click to select individual tabs or Shift+Click to select a range of tabs.
If you use Find and Replace dialogue, you can select All sheets

@TP123

3. Have Calc look for this value in formulas? E.g. if I have a formula that contains “dd/mm/yyyy” this will translate in 01/05/2026. However, what I would like to find is the string “dd/mm/yyyy”

In the Find and Replace dialogue, in Search in, you can select Formulae

You might find the Calc Guide helpful as a reference, download from English documentation | LibreOffice Documentation - LibreOffice User Guides