Pager Property (FpSpread)

Visual Basic
C#

'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

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.

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.

C#

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);

Visual Basic

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)

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

Reference

FpSpread Class
FpSpread Members
PagerInfo Class

User-Task Documentation

Customizing the Page Navigation