Spread for ASP.NET 11 Product Documentation
Pager Property (FpSpread)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : Pager Property
Gets the page navigation information for the component.
Syntax
'Declaration
 
Public ReadOnly Property Pager As PagerInfo
'Usage
 
Dim instance As FpSpread
Dim value As PagerInfo
 
value = instance.Pager
public PagerInfo Pager {get;}

Property Value

PagerInfo object containing the page navigation information
Remarks

When a sheet contains more rows than can be displayed in the component at once, the Spread component automatically creates pages that each contain a subset of the rows of that sheet. When there is more than one page for a sheet, you can decide which page navigation aids are displayed in the tool bars at the top or bottom of the component.

Spread can display either Next (>>) and Previous (<<) arrows, page numbers, or both as page navigation aids. You can display these page navigation aids at the top of the component (above the sheet) in a separate tool bar, the bottom of the component (below the sheet and below the other tool bar) in a separate tool bar, on the tool bar along with the sheet name tabs and command buttons, or some combination of these.

Example
This example creates a sheet with five columns and 150 rows, a PageSize of 30 rows and a PageCount of 3. The page navigation is positioned on the top of the spreadsheet, and the user is taken to the last page of the sheet.
FpSpread1.Columns.Count=5;
FpSpread1.Rows.Count=150;
FpSpread1.ActiveSheetView.PageSize=30;
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top;
FpSpread1.Pager.PageCount=3;
FpSpread1.GotoPage(4);
FpSpread1.Columns.Count=5
FpSpread1.Rows.Count=150
FpSpread1.ActiveSheetView.PageSize=30
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top
FpSpread1.Pager.PageCount=3
FpSpread1.GotoPage(4)
See Also

Reference

FpSpread Class
FpSpread Members
PagerInfo Class

User-Task Documentation

Customizing the Page Navigation