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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
PagerInfo Class

User-Task Documentation

Customizing the Page Navigation