Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ShowRow Method
Row index of the viewport that has this row
Row index to move
New vertical position of the row
Example


In This Topic
    ShowRow Method (FpSpread)
    In This Topic
    Moves a row in the specified viewport to the specified position in the component.
    Syntax
    'Declaration
     
    Public Sub ShowRow( _
       ByVal rowViewportIndex As Integer, _
       ByVal row As Integer, _
       ByVal verticalPosition As VerticalPosition _
    ) 
    'Usage
     
    Dim instance As FpSpread
    Dim rowViewportIndex As Integer
    Dim row As Integer
    Dim verticalPosition As VerticalPosition
     
    instance.ShowRow(rowViewportIndex, row, verticalPosition)
    public void ShowRow( 
       int rowViewportIndex,
       int row,
       VerticalPosition verticalPosition
    )

    Parameters

    rowViewportIndex
    Row index of the viewport that has this row
    row
    Row index to move
    verticalPosition
    New vertical position of the row
    Remarks

    This method scrolls the spreadsheet so that the specified row 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 row 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.ShowRow(0, 15, FarPoint.Win.Spread.VerticalPosition.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.ShowRow(0, 15, FarPoint.Win.Spread.VerticalPosition.Center)
    See Also