Spread Windows Forms 11.0 Product Documentation
SheetIndex Property (SearchDialog)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SearchDialog Class : SheetIndex Property
Gets or sets the index of the sheet to search.
Syntax
'Declaration
 
Public Overridable Property SheetIndex As Integer
'Usage
 
Dim instance As SearchDialog
Dim value As Integer
 
instance.SheetIndex = value
 
value = instance.SheetIndex
public virtual int SheetIndex {get; set;}

Property Value

Integer index of sheet to search
Remarks
The sheet index is zero-based, so the first sheet has an index of 0.
Example
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;
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
See Also

Reference

SearchDialog Class
SearchDialog Members