Gets or sets which page navigation aids are displayed in the Spread component.

Syntax

Visual Basic (Declaration)
Public Property Mode As PagerMode

Visual Basic (Usage)	Copy Code
Dim instance As PagerInfo Dim value As PagerMode instance.Mode = value value = instance.Mode

C#
public PagerMode Mode {get; set;}

Property Value

PagerMode setting

Exceptions

Exception	Description
System.InvalidOperationException	Property must be PagerMode.NextPrev when position is Command Bar.

Remarks

A sheet can display next and previous arrows (NextPrev), numbers (Number), or both (Both).

Note: The only page navigation aids that the component displays on the command bar are the next (>>) and previous (<<) arrows regardless of the Mode property setting. The page numbers, if displayed, are displayed in a separate area depending on the setting of the Position property.

Example

C#	Copy Code
FpSpread1.Columns.Count = 5; FpSpread1.Rows.Count = 150; FpSpread1.ActiveSheetView.PageSize = 30; FarPoint.Web.Spread.PagerInfo pinf; pinf = FpSpread1.Pager; pinf.Align = HorizontalAlign.Right; pinf.BackColor = Color.Yellow; pinf.CssClass = "CssStyle1"; pinf.Font.Bold = true; pinf.ForeColor = Color.Red; pinf.Mode = FarPoint.Web.Spread.PagerMode.NextPrev; pinf.PageCount = 30; pinf.Position = FarPoint.Web.Spread.PagerPosition.Top;

Copy Code

FpSpread1.Columns.Count = 5;
FpSpread1.Rows.Count = 150;
FpSpread1.ActiveSheetView.PageSize = 30;
 
FarPoint.Web.Spread.PagerInfo pinf;
pinf = FpSpread1.Pager;
pinf.Align = HorizontalAlign.Right;
pinf.BackColor = Color.Yellow;
pinf.CssClass = "CssStyle1";
pinf.Font.Bold = true;
pinf.ForeColor = Color.Red;
pinf.Mode = FarPoint.Web.Spread.PagerMode.NextPrev;
pinf.PageCount = 30;
pinf.Position = FarPoint.Web.Spread.PagerPosition.Top;

Visual Basic	Copy Code
FpSpread1.Columns.Count = 5 FpSpread1.Rows.Count = 150 FpSpread1.ActiveSheetView.PageSize = 30 Dim pinf As FarPoint.Web.Spread.PagerInfo pinf = FpSpread1.Pager pinf.Align = HorizontalAlign.Right pinf.BackColor = Color.Yellow pinf.CssClass = "CssStyle1" pinf.Font.Bold = True pinf.ForeColor = Color.Red pinf.Mode = FarPoint.Web.Spread.PagerMode.NextPrev pinf.PageCount = 30 pinf.Position = FarPoint.Web.Spread.PagerPosition.Top

Visual Basic

Copy Code

FpSpread1.Columns.Count = 5
FpSpread1.Rows.Count = 150
FpSpread1.ActiveSheetView.PageSize = 30

Dim pinf As FarPoint.Web.Spread.PagerInfo
pinf = FpSpread1.Pager
pinf.Align = HorizontalAlign.Right
pinf.BackColor = Color.Yellow
pinf.CssClass = "CssStyle1"
pinf.Font.Bold = True
pinf.ForeColor = Color.Red
pinf.Mode = FarPoint.Web.Spread.PagerMode.NextPrev
pinf.PageCount = 30
pinf.Position = FarPoint.Web.Spread.PagerPosition.Top

Requirements

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