Spread ASP.NET 14
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