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

Syntax

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

Visual Basic (Usage)	Copy Code
Dim instance As SpreadView Dim sheetIndex As Integer Dim rowViewportIndex As Integer Dim value As Integer value = instance.GetViewportBottomRow(sheetIndex, rowViewportIndex)

C#
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.

C#	Copy Code
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());

Copy Code

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	Copy Code
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())

VB.NET

Copy Code

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())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8