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

Glossary Item Box

You can also add some advanced options to the search dialog for the end-user 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 (in the top half of the 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 give the user a search dialog with several settings preset.

Example

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)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.