PageSize Property

Gets or sets the number of rows to display at a time.

Syntax

Visual Basic
C#

'Declaration
 
Public Property PageSize As Integer

'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.PageSize = value
 
value = instance.PageSize

public int PageSize {get; set;}

Property Value

Integer number of rows to display

Remarks

This property is available at run time only.

Example

This example creates a spreadsheet with 6 columns and 20 rows and single-selection mode in which the user can select a row but is unable to edit the data.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
int i,j;
sv.ColumnCount=6;
sv.PageSize=20;
sv.RowCount=20;
sv.OperationMode=FarPoint.Web.Spread.OperationMode.SingleSelect;
for(i=0;i<=19;i++)
{
for(j=0;j<=5;j++)
sv.SetValue(i,j,100+i);
}

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim i,j As Integer
sv=FpSpread1.ActiveSheetView
sv.ColumnCount=6
sv.PageSize=20
sv.RowCount=20
sv.OperationMode=FarPoint.Web.Spread.OperationMode.SingleSelect
For i=0 To 19
For j=0 To 5
sv.SetValue(i,j,100+i)
Next j
Next i

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members

User-Task Documentation

Customizing the Page Size (Rows to Display)