Gets the number of viewport columns in the specified sheet.

Syntax

Visual Basic (Declaration)
Public Overloads Function GetColumnViewportCount( _ ByVal sheetIndex As Integer _ ) As Integer

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

C#
public int GetColumnViewportCount( int sheetIndex )

Parameters

sheetIndex: Sheet index

Return Value

Integer number of viewport columns

Exceptions

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

Remarks

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

Example

This example uses the GetColumnViewportCount method.

C#	Copy Code
FarPoint.Win.Spread.SpreadView sv = new FarPoint.Win.Spread.SpreadView(fpSpread1); sv = fpSpread1.GetRootWorkbook(); sv.AddViewport(0, 1); int i; i = sv.GetColumnViewportCount(sv.ActiveSheetIndex); MessageBox.Show("There are " + i + " viewports in this sheet");

Copy Code

FarPoint.Win.Spread.SpreadView sv = new FarPoint.Win.Spread.SpreadView(fpSpread1);
sv = fpSpread1.GetRootWorkbook();
sv.AddViewport(0, 1);
int i;
i = sv.GetColumnViewportCount(sv.ActiveSheetIndex);
MessageBox.Show("There are " + i + " viewports in this sheet");

VB.NET	Copy Code
Dim sv As New FarPoint.Win.Spread.SpreadView(FpSpread1) sv = FpSpread1.GetRootWorkbook() sv.AddViewport(0, 1) Dim i As Integer i = sv.GetColumnViewportCount(sv.ActiveSheetIndex) MessageBox.Show("There are " & i & " viewports in this sheet")

VB.NET

Copy Code

Dim sv As New FarPoint.Win.Spread.SpreadView(FpSpread1)
sv = FpSpread1.GetRootWorkbook()
sv.AddViewport(0, 1)

Dim i As Integer
i = sv.GetColumnViewportCount(sv.ActiveSheetIndex)
MessageBox.Show("There are " & i & " viewports in this sheet")

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