2.2.10 findreplace

Menu Information

Edit: Find/ Replace

Brief Information

Open the Find and Replace dialog

Additional Information

X-Function not designed for Auto GetN Dialog.

Minimum Origin Version Required: 8.1 SR0

Command Line Usage

1. findreplace option:=0; //open Find and Replace dialog with Find tab active

2. findreplace option:=1; //open Find and Replace dialog with Replace tab active

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Find or Replace option

Input

int

0
Use to control which tab is activated when opening the Find and Replace dialog.

Option list:

  • find:Find
    Activate the Find tab for searching data.
  • replace:Replace
    Activate the Replace tab for replacing one value with another value.
Search String str

Input

string

0

Specify the string you want to search.

Description

This X-Function is used to open the Find and Replace dialog, which contains two tabs: the Find tab and the Replace tab. The former is for searching and the latter for replacing. Options are provided to activate one of these two tab when opening the dialog.

More Information

For more information about finding and replacing data in a worksheet or matrix sheet, please refer to our User Guide.