-
Spread Windows Forms 18 Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Allowing the User to Perform an Advanced Search
You can provide a more advanced search dialog for the end-users to allow them to search other areas of the spreadsheet, including cell notes and cell tags.
There are several advanced options you can set that extend the scope of the search. The advanced options include:
Include cell text- searches the row and column cells.
Include cell tags- searches the cell tags in the data area.
Include cell notes- 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.
Using Code
Use the SearchWithDialogAdvanced methods for the FpSpread component to customize the advanced search dialog.
Example
This example uses the SearchWithDialogAdvanced method and provides the users a search dialog with several settings preset.
fpSpread1.SearchWithDialogAdvanced(0,4,"This",true,true,false,false,0,0);fpSpread1.SearchWithDialogAdvanced(0,4,"This",True,True,False,False,0,0)