Spread Windows Forms 11.0 Product Documentation
ActiveSheetIndex Property (FpSpread)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : ActiveSheetIndex Property
Gets or sets the index of the active sheet in the component.
Syntax
'Declaration
 
Public Property ActiveSheetIndex As Integer
'Usage
 
Dim instance As FpSpread
Dim value As Integer
 
instance.ActiveSheetIndex = value
 
value = instance.ActiveSheetIndex
public int ActiveSheetIndex {get; set;}

Property Value

Integer index of the currently selected sheet
Remarks

This property is available at run time only.

Example
This example sets the active sheet.
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.ActiveColumnIndex = 2;
fpSpread1.ActiveSheet.ActiveRowIndex = 2;
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.Sheets.Count = 3;
fpSpread1.ActiveSheetIndex = 1;
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.ActiveColumnIndex = 2
fpSpread1.ActiveSheet.ActiveRowIndex = 2
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
fpSpread1.Sheets.Count = 3
fpSpread1.ActiveSheetIndex = 1
See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with the Active Sheet