Find and Replace Data

1. Click on the data table.

2. Click the Find and Replace button on the Table ribbon tab or press CTRL+F.

NOTE. Formatting setup is available in the desktop application only.

To select search value format, use drop-down menu of the Format button containing the following commands:

• Specify Format.  The standard formatting dialog box opens, in which the required format is set. Custom format is displayed in the Sample box. If no format is defined, the field shows No Format Set.

• Choose Format from Cell. Hides the dialog box. After selecting a report cell this dialog box is displayed again, and the Sample box shows format of the selected cell.

• Clear Find Format. Resets the selected format. The Sample box shows No Format Set.

Select the Match Case checkbox to consider the case of entered characters.

To find only cells that contain the exact value entered for search, select the Whole Cell checkbox.

To select search order, use the Search Order drop-down list containing the following values:

• By rows.

• By columns.

To select a search object, use the checkboxes:

• Value. Search is executed by cell values.

• Text. Search is executed by cell text. The displayed text may differ from cell value due to displayed value format settings. For example, a cell may contain the 2.5879 value, but the displayed value is 2.59.

• Formula. Search is executed by the formulas, by which cell values are calculated.

• Metadata. Search is executed by metadata of observations in the table. For calculated elements, search is performed by their formula.
  Metadata consists of data provider name and values of series mandatory attributes corresponding to the observation.

NOTE. The Formula and Metadata checkboxes are available only in the desktop application.

1. Click on the data table.

2. Click the Find and Replace button on the Table ribbon tab or press CTRL+F.