Enter the text that you want to find, or select a previous search from the list.
Search options are listed under the Find box and in the Other options area of the dialog.
Entire CellsWhole words only
Searches through all of the sheets in the current spreadsheet file.
Enter the replacement text, or select a recent replacement text or style from the list.
Replacement options are listed under the Find box and in the Other options area of the dialog.
Finds and selects the previous occurrence of the text or format that you are searching for in the document.
Finds and selects the next occurrence of the text or format that you are searching for in the document.
Replaces the selected text or format that you searched for, and then searches for the next occurrence.
Replaces all of the occurrences of the text or format that you want to replace. Repeat this command until all replacements on your slide have been made.
Shows more or fewer search options. Click this label again to hide the extended search options.
Current selection only
Searches only the selected text or cells.
Search starts at the current cursor position and goes backwards to the beginning of the file.
Allows you to use wildcards in your search.
Paragraph Styles / Including StylesCell Styles
Searches for text formatted with the style that you specify. Select this checkbox, and then select a style from the Find list. To specify a replacement style, select a style from the Replace list.
After you select the attributes that you want to search for, the Paragraph Styles box in the Other options area of the LibreOffice Writer Find & Replace dialog changes to Including Styles.
If you want to search for text in which attributes were set by using direct formatting and styles, select the Including Styles box.
In Writer, you can select to include the comment texts in your searches.
Finds specific text formatting features, such as font types, font effects, and text flow characteristics.
Click in the Find or the Replace box, and then click this button to remove the search criteria based on formats.
The search criteria for formatting attributes are displayed under the Find or the Replace box.
Determines the order for searching the cells.
Searches from left to right across the rows.
Searches from top to bottom through the columns.
Searches for the characters that you specify in formulas and in fixed (not calculated) values. For example, you could look for formulas that contain 'SUM'.
Searches for the characters that you specify in values and in the results of formulas.
Searches for the characters that you specify in the comments that are attached to the cells.
After you close the Find & Replace dialog, you can still search using the last search criteria that you entered, by pressing Shift+CommandCtrl+F.