Allowing the User to Perform an Advanced Search

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:

Include cell text- this searches the row and column cells.
Include cell tags- this searches the cell tags in the data area.
Include cell notes- this searches the cell notes in the data area.

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)