The XL3SetProperty formula updates the Anaplan XL page properties in the workbook.
Property | Description | Value |
Page | The page number to jump to. Note that on the web you shouldn't combine this with a pager the user can access, as the formula will conflict with it. Use for a fully formula-driven pager only. | Numeric |
Enabled | Toggle whether the pager is active. If not, then it won't restrict the output of the report. | TRUE or FALSE |
Visible | Toggle whether the pager is visible. | TRUE or FALSE |