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

You can have the component display a search (find) dialog for the end-user to allow them to search the text (unformatted data) of cells in a sheet for a particular string of text, as shown in the following figure.

You can customize many features of the search dialog box by setting its properties. In addition, you can display a default search string in the Find what combo box. And you can set the check boxes for these options:

For information about the advanced options available on the search dialog, refer to Allowing the User to Perform an Advanced Search.

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

Using Code

Use the SearchWithDialog methods for the FpSpread component to customize the search dialog.

Example

This example provides a search dialog with several settings preset. In this case, it as an exact-match search on the fourth sheet (Sheet 3) for the phrase "Not Available" and start at the first row and column.

C#
Copy Code
fpSpread1.SearchWithDialog(3,"Not Available",true,true,false,false,0,0);
VB
Copy Code
fpSpread1.SearchWithDialog(3,"Not Available",True,True,False,False,0,0)