Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SpreadView Class / ShowCell Method
Viewport row index
Viewport column index
Row index in that viewport
Column index in that viewport
New vertical position of cell
New horizontal position of cell
Example


In This Topic
    ShowCell Method (SpreadView)
    In This Topic
    Moves the specified cell in the specified viewport to the specified position.
    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 SpreadView
    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
    Viewport row index
    columnViewportIndex
    Viewport column index
    row
    Row index in that viewport
    column
    Column index in that viewport
    verticalPosition
    New vertical position of cell
    horizontalPosition
    New horizontal position of 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
    FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
    sv.AddViewport(0, 0);
    sv.ShowCell(1, 1, 6, 4, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center);
    Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
    Dim hp As New FarPoint.Win.Spread.HorizontalPosition()
    Dim vp As New FarPoint.Win.Spread.VerticalPosition()
    sv.AddViewport(0, 0)
    sv.ShowCell(1, 1, 6, 4, vp.Center, hp.Center)
    See Also