Spread Windows Forms 11.0 Product Documentation
Allowing the User to Perform an Advanced Search
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Customizing Sheet Interaction > Customizing User Searching of Data > Allowing the User to Perform an Advanced Search

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. For a description of the standard search options (shown in the top half of the advanced dialog), refer to Allowing the User to Perform a Standard 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.

For information about performing a search without a dialog, refer to Searching for Data with Code.

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)