Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / PageSize Property
Example


In This Topic
    PageSize Property
    In This Topic
    Gets or sets the number of rows to display at a time.
    Syntax
    '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);
}
    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
    See Also

    Reference

    SheetView Class
    SheetView Members

    User-Task Documentation

    Customizing the Page Size (Rows to Display)