Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Developer's Guide / Customizing Row or Column Interaction / Customizing User Searching of Data / Allowing the User to Perform an Advanced Search
In This Topic
    Allowing the User to Perform an Advanced Search
    In This Topic

    You can provide a more advanced search dialog for the end-users to allow them to search other areas of the spreadsheet, including cell notes and cell tags.

    Advanced Search Dialog

    There are several advanced options you can set that extend the scope of the search. The advanced options include:

    For information about performing a search with the search dialog with the standard options, refer to Allowing the User to Perform a Standard Search.

    Using Code

    Use the SearchWithDialogAdvanced methods for the FpSpread component to customize the advanced search dialog.

    Example

    This example uses the SearchWithDialogAdvanced method and provides the users a search dialog with several settings preset.

    C#
    Copy Code
    fpSpread1.SearchWithDialogAdvanced(0,4,"This",true,true,false,false,0,0);
    
    VB
    Copy Code
    fpSpread1.SearchWithDialogAdvanced(0,4,"This",True,True,False,False,0,0)
    
    See Also