Spread Windows Forms 8.0 Product Documentation
Allowing the User to Perform a Standard Search

You can pop-up 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.

There are several options you can set by manipulating the properties of the search dialog. 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 give the user 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.

Example

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)

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback