GetViewportBottomRow(Int32,Int32) Method

Gets the index of the bottom row of the specified viewport row.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetViewportBottomRow( _
   ByVal sheetIndex As Integer, _
   ByVal rowViewportIndex As Integer _
) As Integer

'Usage
 
Dim instance As SpreadView
Dim sheetIndex As Integer
Dim rowViewportIndex As Integer
Dim value As Integer
 
value = instance.GetViewportBottomRow(sheetIndex, rowViewportIndex)

public int GetViewportBottomRow( 
   int sheetIndex,
   int rowViewportIndex
)

Parameters

sheetIndex: Sheet index
rowViewportIndex: Viewport row index

Return Value

Integer index of the bottom row of cells in the specified viewport row

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified sheet index is not valid; must be between zero and the number of sheets.

Remarks

The sheet index is zero-based, so the first sheet has an index of 0.

The viewport row index is zero-based, so the first (top) viewport row has an index of 0.

Example

This example uses the GetViewportBottomRow method.

FarPoint.Win.Spread.SpreadView sv;
int i;
sv = fpSpread1.GetRootWorkbook();
sv.AddViewport(0, 0);
i = sv.GetViewportBottomRow(0, 0);
MessageBox.Show("The bottom row of the viewport is " + i.ToString());

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView
Dim i As Integer
sv = FpSpread1.GetRootWorkbook()
sv.AddViewport(0, 0)
i = sv.GetViewportBottomRow(0, 0)
MessageBox.Show("The bottom row of the viewport is " & i.ToString())

Reference

SpreadView Class
SpreadView Members
Overload List