Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ShowActiveCell Method
New position (vertical coordinate) of active cell
New position (horizontal coordinate) of active cell
Example


In This Topic
    ShowActiveCell Method (FpSpread)
    In This Topic
    Moves the active cell to the specified position in the component.
    Syntax
    'Declaration
     
    Public Sub ShowActiveCell( _
       ByVal verticalPosition As VerticalPosition, _
       ByVal horizontalPosition As HorizontalPosition _
    ) 
    'Usage
     
    Dim instance As FpSpread
    Dim verticalPosition As VerticalPosition
    Dim horizontalPosition As HorizontalPosition
     
    instance.ShowActiveCell(verticalPosition, horizontalPosition)
    public void ShowActiveCell( 
       VerticalPosition verticalPosition,
       HorizontalPosition horizontalPosition
    )

    Parameters

    verticalPosition
    New position (vertical coordinate) of active cell
    horizontalPosition
    New position (horizontal coordinate) of active cell
    Remarks

    This method scrolls the spreadsheet so that the active cell appears in the specified position of the display. For example, you may wish to move the active cell to the center of the component display.

    To set the active cell, refer to the SetActiveCell method.

    Example
    This example moves the active cell to the specified position.
    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.SetActiveCell(15, 15);
    fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center);
    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.SetActiveCell(15, 15)
    fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center)
    See Also