XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Pager Properties

Revision as of 15:42, 27 June 2013 by NMaudgil (talk)

This form has several properties that adjust how the table pager behaves.

Table 
Determines the table that is associated with this pager
Grid  
New in v7.5 - Paging for grids. Determines the grid that is associated with this pager. You can select whether the paging is on grid rows or columns.
Page size 
Sets how many rows/columns are displayed per page
Placement 
Controls how the pager control behaves when cells around it are resized
  • Free Floating - the pager is not affected by any cell changes
  • Move - the pager moves when the cell it is on moves
  • Move and Size - the pager moves when the cell it is on moves, and is resized when cells beneath it are resized
Layout
Sets the pager controls horizontally or vertically
  • Show Texbox - determines whether the pager text is displayed ie Page 1 of 4
Ignore pager on save to Excel 
When the published report is saved back to Excel, this determines whether the pager is ignored