PagerMode Enumeration

Specifies which type of page navigation aids are shown in the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum PagerMode 
   Inherits System.Enum

'Usage
 
Dim instance As PagerMode

public enum PagerMode : System.Enum

Members

Member	Description
Both	Displays both the page numbers and page arrows of the pages in a sheet
NextPrev	Displays arrows for next page and previous page, called the Next and Previous arrows
Number	Displays page numbers of the pages in a sheet
Slider	Displays a slider

Remarks

Use these settings with the PagerInfo class's Mode property to specify which page navigation aids to display.

A sheet can have multiple pages depending on how many rows can display at a time. How many rows are displayed depends on the height of the Spread component, the setting of the SheetView class PageSize property, and the number of rows of data. The component can display the page numbers and the page arrows (for next and previous pages). For information on where the page numbers and page arrows appear on the Spread component, refer to the PagerPosition enumeration and the PagerInfo class's Position property.

Example

This example creates a spreadsheet with 5 columns and 150 rows. The properties for page navigation are assigned.

FpSpread1.Columns.Count=5;
FpSpread1.Rows.Count=150;
FpSpread1.ActiveSheetView.PageSize=30;
FpSpread1.Pager.Align=HorizontalAlign.Right;
FpSpread1.Pager.BackColor=Color.Yellow;
FpSpread1.Pager.Font.Bold=true;
FpSpread1.Pager.ForeColor=Color.DarkBlue;
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top;
FpSpread1.Pager.Mode=FarPoint.Web.Spread.PagerMode.Both;
FpSpread1.Pager.PageCount=3;

Visual Basic

FpSpread1.Columns.Count=5
FpSpread1.Rows.Count=150
FpSpread1.ActiveSheetView.PageSize=30
FpSpread1.Pager.Align=HorizontalAlign.Right
FpSpread1.Pager.BackColor=Color.Yellow
FpSpread1.Pager.Font.Bold=True
FpSpread1.Pager.ForeColor=Color.DarkBlue
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top
FpSpread1.Pager.Mode=FarPoint.Web.Spread.PagerMode.Both
FpSpread1.Pager.PageCount=3

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.PagerMode

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FarPoint.Web.Spread Namespace
Mode Property
PagerPosition Enumeration

User-Task Documentation

Customizing Page Navigation