Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Pager Property
Example


In This Topic
    Pager Property (FpSpread)
    In This Topic
    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)
    See Also