SpreadJS Designer enables the user to search for data such as a string or number in your worksheet. You can locate the data as well as replace the specific data with something else.

You can find something by using "Ctrl+F" shortcut keys or the "Find" button in the "Home" > "Editing" tab group. These actions open the find dialog box in SpreadJS designer. Similar to Excel, you can open the Find dialog using the shortcut keys when the focus is on SpreadJS Designer. 

The Find dialog box prevents the opening of any other dialog box.

The following image shows the find dialog box.

• Find All to find all the occurrences of the string.
• Find Next to move to next occurrence of the string from the current cursor position.
• Close to close the dialog box.

Working with Replace Tab

This option allows the user to enter the string to find in the Find what textbox and enter the string which can replace the found string in Replace with textbox as shown in below image:

• Replace All: Click on this option to replace all the occurrences of the old string with the new string.
• Replace: Click on this to replace the string on current cursor position with the new string.

Working with Option button

SpreadJS Designer also enables the user to apply conditions on their search using Option button.

The following image shows the dialog when a user presses the Option button.

 

User can implement the find and replace conditions as follows:

Option	Explanation
Within	Worksheet: To find the string within a particular sheet. Workbook: To find the string in all the worksheets of a workbook. Match case: Select the checkbox if user wants to match the case of entered string. Match exactly: Select the checkbox if user wants to match the content of whole cell.
Search	By Rows: Will list the Row value of the entered string. By Columns: Will list the column value of the entered string.
Look in	Values: Normal search in the worksheet or workbook. Formula: It list cells where the searched formula is implemented. Use Wildcards: Select the checkbox if user has entered any wildcard characters criteria while Find or Replace operations.