Spread for ASP.NET 7.0 Product Documentation
PageSize Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : PageSize Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property PageSize As Integer
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As Integer
 
instance.PageSize = value
 
value = instance.PageSize
C# 
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.
C#Copy Code
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 BasicCopy Code
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.