EndSheetIndex Property

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property EndSheetIndex As Integer

'Usage
 
Dim instance As AdvancedSearchDialog
Dim value As Integer
 
instance.EndSheetIndex = value
 
value = instance.EndSheetIndex

public virtual int EndSheetIndex {get; set;}

Property Value

Integer index of the ending sheet to search

Example

This example customizes the advanced search dialog.

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 Basic

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

Reference

AdvancedSearchDialog Class
AdvancedSearchDialog Members