GetViewportTopRow(Int32,Int32) Method

Gets the index of the top row of the specified viewport row for the specified sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetViewportTopRow( _
   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.GetViewportTopRow(sheetIndex, rowViewportIndex)

public int GetViewportTopRow( 
   int sheetIndex,
   int rowViewportIndex
)

Parameters

sheetIndex: Sheet index
rowViewportIndex: Viewport row index

Return Value

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

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 GetViewportTopRow method.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.AddViewport(0, 0);
MessageBox.Show("The top-most row of the viewport is " + sv.GetViewportTopRow(0, 0).ToString())

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.AddViewport(0, 0)
MessageBox.Show("The top-most row of the viewport is " & sv.GetViewportTopRow(0, 0).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

Reference

SpreadView Class
SpreadView Members
Overload List