Customizing the Page Size (Rows to Display)

In this Web Form version of Spread, a page is the amount of data of a sheet that can be displayed at one time. When the sheet contains more rows than can be displayed in the component, Spread automatically creates pages that contain the other rows. (These are not to be confused with HTML pages.) For sheets that have more rows than fit in the display area, the sheet has multiple pages.

The page size is the number or rows that are displayed at one time. By default, the page size is ten, so ten rows are displayed. If you would like to display more than ten rows (or ten records for a bound spreadsheet), set the PageSize property to the number of records you want to display on every page.

For more information on setting the page navigation, refer to Customizing Page Navigation.

Using Shortcut Object

Set the PageSize property for the sheet using the ActiveSheetView shortcut of the FpSpread component.

Example

The following code shows how to set the page size to display 15 rows.

C#	Copy Code
FpSpread1.ActiveSheetView.PageSize = 15;

VB	Copy Code
FpSpread1.ActiveSheetView.PageSize = 15

Using Code

Set the PageSize property for the SheetView class.

Example

The following code shows how to set the page size to display 15 rows.

C#	Copy Code
FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView; sv.PageSize = 15;

VB	Copy Code
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.PageSize = 15

Using the Spread Designer

Select the Settings tab.
Select the General icon under the Sheet Settings section.
Check the AllowPage check box and specify the number of rows in the Page Size edit box.
Click Apply and Exit to close the Spread Designer.