SpreadJS 15
SpreadJS Designer / Work in the Designer / Find and Replace
In This Topic
    Find and Replace
    In This Topic

    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.

    In the above image, enter the string to be found in the text box given in the "Find what:" input field and then click on

    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:

    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.