Spread for ASP.NET 9.0 Product Documentation
GotoPage Method
Example 


Index of specified page
Scrolls through the sheet in the component to the specified page.
Syntax
'Declaration
 
Public Sub GotoPage( _
   ByVal pageIndex As Integer _
) 
'Usage
 
Dim instance As FpSpread
Dim pageIndex As Integer
 
instance.GotoPage(pageIndex)
public void GotoPage( 
   int pageIndex
)

Parameters

pageIndex
Index of specified page
Remarks

Use this method to scroll to a specific page of the active sheet using code.

You can allow users to scroll to a specific page of the active sheet by using the Mode, Position, and Align properties to provide page navigation aids on the tool bars of the component.

Example
This example creates a spreadsheet with five columns and 150 rows, a PageSize of 30 rows and a PageCount of 3. The Pager is positioned on the top of the spreadsheet, and the user would be 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
Align Property
Mode Property
Position Property

 

 


Copyright © GrapeCity, inc. All rights reserved.