FarPoint.Win.Spread
SearchCellText Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > AdvancedSearchDialog Class : SearchCellText Property


Gets or sets whether to search the text of cells.

Syntax

Visual Basic (Declaration) 
Public Overridable Property SearchCellText As Boolean
Visual Basic (Usage)Copy Code
Dim instance As AdvancedSearchDialog
Dim value As Boolean
 
instance.SearchCellText = value
 
value = instance.SearchCellText
C# 
public virtual bool SearchCellText {get; set;}

Return Value

Boolean: true if the search includes cell text; false otherwise

Example

This example customizes the advanced search dialog.
C#Copy Code
FarPoint.Win.Spread.AdvancedSearchDialog sd;
fpSpread1.SearchWithDialogAdvanced("Test");
sd = fpSpread1.SearchDialog;
sd.SetCustomTextToDefaults();
sd.StartSheetIndex = 0;
sd.EndSheetIndex = 0;
sd.SearchCellText = true;
sd.SearchNotes = true;
sd.SearchTags = true;
Visual BasicCopy Code
Dim sd As FarPoint.Win.Spread.AdvancedSearchDialog
FpSpread1.SearchWithDialogAdvanced("Test")
sd = FpSpread1.SearchDialog
sd.SetCustomTextToDefaults()
sd.StartSheetIndex = 0
sd.EndSheetIndex = 0
sd.SearchCellText = True
sd.SearchNotes = True
sd.SearchTags = True

See Also