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


Gets or sets the index of the sheet at which to start the search.

Syntax

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

Return Value

Integer index of the starting sheet to search

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