Find & Replace /text/shared/01/02100000.xhp
Find & Replace Finds or replaces text or formats in the current document.
Find Toolbar Type the text to search in the current document. Press Enter to search the text. Click to search the next occurrence in downward direction. Click to search the next occurrence in upward direction. Find 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. Match case case sensitivity;searching Distinguishes between uppercase and lowercase characters. searching;formatted numbers searching;formatted display finding;formatted numbers finding;formatted display

Formatted display

Includes number formatting characters in the search. Entire CellsWhole words only Searches for whole words or cells that are identical to the search text. searching; all sheets finding; in all sheets sheets; searching all All sheets Searches through all of the sheets in the current spreadsheet file. Searches through all of the sheets in the current spreadsheet file. Replace 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. Find All Finds and selects all instances of the text or the format that you are searching for in the document (only in Writer and Calc documents). copied text as hidden help, see issue 115137 Finds and selects all instances of the text or the format that you are searching for in the document (only in Writer and Calc documents). Find Previous Finds and selects the previous occurrence of the text or format that you are searching for in the document. Find Next Finds and selects the next occurrence of the text or format that you are searching for in the document. Replace Replaces the selected text or format that you searched for, and then searches for the next occurrence. Replace All 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. Other options Shows more or fewer search options. Click this label again to hide the extended search options. finding; selections Current selection only Searches only the selected text or cells. Replace backwards Search starts at the current cursor position and goes backwards to the beginning of the file. Regular expressions Allows you to use regular expressions in your search.i72448 Ext help text not found within switches. Solution: Keep switched text for normal display, add hidden help text as "fall through". Allows you to use regular expressions in your search. had to copy extended help to outside of switch construct - see issue 72448 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. 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 %PRODUCTNAME 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. Match character width (only if Asian languages are enabled) Distinguishes between half-width and full-width character forms. Sounds like (Japanese) (only if Asian languages are enabled) Lets you specify the search options for similar notation used in Japanese text. Select this checkbox, and then click the Sounds button to specify the search options. Sets the search options for similar notation used in Japanese text. Searching in Japanese Comments In Writer, you can select to include the comment texts in your searches. Attributes Format Finds specific text formatting features, such as font types, font effects, and text flow characteristics. No Format Click in the Find or the Replace box, and then click this button to remove the search criteria based on formats. 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. Direction Determines the order for searching the cells. Rows Searches from left to right across the rows. Searches from left to right across the rows. Columns Searches from top to bottom through the columns. Searches from top to bottom through the columns. Search in Formulas 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 formulas and in fixed (not calculated) values. For example, you could look for formulas that contain 'SUM'. Values Searches for the characters that you specify in values and in the results of formulas. Searches for the characters that you specify in values and in the results of formulas. Notes Searches for the characters that you specify in the comments that are attached to the cells. 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.