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


In This Topic
    ActiveSheet Property (FpSpread)
    In This Topic
    Gets or sets the active sheet in the component.
    Syntax
    'Declaration
     
    Public Property ActiveSheet As SheetView
    'Usage
     
    Dim instance As FpSpread
    Dim value As SheetView
     
    instance.ActiveSheet = value
     
    value = instance.ActiveSheet
    public SheetView ActiveSheet {get; set;}

    Property Value

    SheetView object with the currently selected sheet
    Exceptions
    ExceptionDescription
    Specified sheet is not in the collection
    Remarks

    This property is available at run time only.

    Example
    This example sets the active cell and its data in 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