SearchDialog Property

Gets the dialog associated with searching for text in a cell of a sheet in this component.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property SearchDialog As SearchDialog

'Usage
 
Dim instance As FpSpread
Dim value As SearchDialog
 
value = instance.SearchDialog

public SearchDialog SearchDialog {get;}

Property Value

SearchDialog object containing the search dialog

Remarks

The search has these qualifications:

This method only searches the cells in the data area, not the headers.
This method only checks against the formatted string -- the Text in the cell, not the Value.
This method only searches the specified cells in one sheet.
All the cells that contain data that can be represented as a string by the Text property of that cell are searched and that includes hidden and locked cells.
Cell notes and cell tags are not part of the search.

This property is available at run time only.

Example

This example sets up the search dialog.

fpSpread1.SearchWithDialog(""); 
fpSpread1.SearchDialog.AlternateSearch = true; 
fpSpread1.SearchDialog.CaseSensitive = false; 
fpSpread1.SearchDialog.ExactMatch = false;  
fpSpread1.SearchDialog.SearchString = "155"; 
fpSpread1.SearchDialog.SheetIndex = 0; 
fpSpread1.SearchDialog.StartColumnIndex = 0; 
fpSpread1.SearchDialog.StartRowIndex = 0; 
fpSpread1.SearchDialog.UseWildcards = false;

Visual Basic

FpSpread1.SearchWithDialog("") 
FpSpread1.SearchDialog.AlternateSearch = True 
FpSpread1.SearchDialog.CaseSensitive = False 
FpSpread1.SearchDialog.ExactMatch = False 
FpSpread1.SearchDialog.SearchString = "155" 
FpSpread1.SearchDialog.SheetIndex = 0 
FpSpread1.SearchDialog.StartColumnIndex = 0 
FpSpread1.SearchDialog.StartRowIndex = 0 
FpSpread1.SearchDialog.UseWildcards = False

Reference

FpSpread Class
FpSpread Members
Search Method
SearchWithDialog Method

User-Task Documentation

Setting up a Search Dialog