Spread Windows Forms 7.0 Product Documentation
GetViewportBottomRow(Int32,Int32) Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > GetViewportBottomRow Method : GetViewportBottomRow(Int32,Int32) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

sheetIndex: Index of sheet

rowViewportIndex: Index of viewport row

Gets the bottom row of cells of the specified viewport row for the specified sheet.

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 FpSpread 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: Index of sheet
rowViewportIndex: Index of viewport row

Return Value

Integer index of the bottom row of the viewport

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified sheet index is out of range; must be between 0 and the total 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 returns the bottom row in the viewport from the specified sheet.

C#	Copy Code
int i = fpSpread1.GetViewportBottomRow(0, 1); MessageBox.Show(i.ToString());

Visual Basic	Copy Code
Dim i As Integer = FpSpread1.GetViewportBottomRow(0, 1) MessageBox.Show(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