PagerSettings API in JavaScript Pivot Table API control

Allows a set of options for customizing the paging UI with a variety of settings such as UI position, template and visibility to a specific axis info such as page size, paging data.

To use this option, it requires the property enablePaging to be true.

Properties

columnPageSizes

number[]

Allows you to choose from a variety of page sizes in the paging UI that can be used to display the pivot table’s columns.

Defaults to [5, 10, 20, 50, 100]

enableCompactView

boolean

Allows the paging UI to be displayed with the absolute minimum of information by hiding all paging data except for the navigation options.

Defaults to false

isInversed

boolean

When the property is set to “true”, it allows to display the row and column paging options as vice versa.

In pager UI, paging options for column axis will be shown at left-side and for row will be shown at right-side.

Defaults to false

position

PagerPosition

Allows to display the pager UI either at top or bottom of the Pivot Table UI.

Defaults to Bottom

rowPageSizes

number[]

Allows you to choose from a variety of page sizes in the paging UI that can be used to display the pivot table’s rows.

Defaults to [10, 50, 100, 200]

showColumnPageSize

boolean

Allows to show column page size information in the pager UI.

Defaults to true

showColumnPager

boolean

Allows to show or hide column paging options in the pager UI.

Defaults to true

showRowPageSize

boolean

Allows to show row page size information in the pager UI.

Defaults to true

showRowPager

boolean

Allows to show or hide row paging options in the pager UI.

Defaults to true

template

string

Allows the pager UI to be customized by using an HTML string or the element’s ID to display custom elements instead of the standard ones.

Defaults to null