Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ActiveSheetIndex Property
Example


In This Topic
    ActiveSheetIndex Property (FpSpread)
    In This Topic
    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