The XL3SetProperty formula updates the Anaplan XL table properties in the workbook.
Property | Description | Value |
ColumnDisplay | Sets the column(s) shown and their order. | Equivalent to setting up the columns on the Column Display tab in the table properties. The column display must be enabled in the properties for this to take effect. |
Sorting | Sets the column(s) to sort by. | Pairs of column name and direction. If no direction is provided, ascending is assume. e.g.
|
ApplyFormatting | Toggle whether formatting is applied. | TRUE or FALSE |