Customizing User Searching of Data

You can search for data in any of the cells in the workbook by specifying the sheet and the string of data for which to search. You can also have the component display a search dialog and allow the end user to search for data. The methods and properties that relate to searching and search dialogs are part of the Spread component.

The tasks for searching include:

• Allowing the User to Perform a Standard Search
• Allowing the User to Perform an Advanced Search
• Searching for Data with Code

type=note

Note:

• There are limitations to the search. Row and column headers are not searched with the search dialogs; only cells are searched.
• Use the SearchHeaders method to search the headers.
• Not all tags are included when you search and "include tags"; only cell tags are included.
• None of the information in the sheet, column, or row object is included in the search.

See Also

Copying Size and Style of Row/Column on Insert

Customizing Row or Column Interaction

Managing Sorting of Rows of User Data

Managing Filtering of Rows of User Data

Managing Grouping of Rows of User Data

Managing Outlines (Range Groups) of Rows and Columns