Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ShowCell Method
Row index of the viewport
Column index of the viewport
Row index of the cell
Column index of the cell cell
New position (vertical coordinate) of the cell
New position (horizontal coordinate) of the cell
Example


In This Topic
    ShowCell Method (FpSpread)
    In This Topic
    Moves the specified cell in the specified viewport to the specified position in the component.
    Syntax
    'Declaration
     
    Public Sub ShowCell( _
       ByVal rowViewportIndex As Integer, _
       ByVal columnViewportIndex As Integer, _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal verticalPosition As VerticalPosition, _
       ByVal horizontalPosition As HorizontalPosition _
    ) 
    'Usage
     
    Dim instance As FpSpread
    Dim rowViewportIndex As Integer
    Dim columnViewportIndex As Integer
    Dim row As Integer
    Dim column As Integer
    Dim verticalPosition As VerticalPosition
    Dim horizontalPosition As HorizontalPosition
     
    instance.ShowCell(rowViewportIndex, columnViewportIndex, row, column, verticalPosition, horizontalPosition)

    Parameters

    rowViewportIndex
    Row index of the viewport
    columnViewportIndex
    Column index of the viewport
    row
    Row index of the cell
    column
    Column index of the cell cell
    verticalPosition
    New position (vertical coordinate) of the cell
    horizontalPosition
    New position (horizontal coordinate) of the cell
    Remarks

    This method scrolls the spreadsheet so that the specified cell in the specified viewport appears in the specified position.

    This method has no effect on the location or positioning of the active cell.

    Example
    This example moves the specified cell in the specified viewport 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.AddViewport(0, 0);
    fpSpread1.ShowCell(0, 0, 15, 15, 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.AddViewport(0, 0)
    fpSpread1.ShowCell(0, 0, 15, 15, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center)
    See Also