Mode Property

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property Mode As PagerMode

'Usage
 
Dim instance As PagerInfo
Dim value As PagerMode
 
instance.Mode = value
 
value = instance.Mode

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

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

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

Reference

PagerInfo Class
PagerInfo Members
PagerMode Enumeration