Spread for ASP.NET 10 Product Documentation
Pager Property (FpSpread)
Example 


Gets the page navigation information for the component.
Syntax
'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
Remarks

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.

Example
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.
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);
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)
Requirements

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

See Also

Reference

FpSpread Class
FpSpread Members
PagerInfo Class

User-Task Documentation

Customizing the Page Navigation

 

 


Copyright © GrapeCity, inc. All rights reserved.