The XL3SetProperty formula updates the Anaplan XL grid display and permission properties in the workbook.
Grid display
Property | Description | Value |
ApplyFormatting | Toggle whether formatting is applied. | TRUE or FALSE |
HierarchiesOnColumns | Sets hierarchies on columns. Will move hierarchies as required. | Hierarchy name or names. |
HierarchiesOnHeaders | Sets hierarchies on headers. Will move hierarchies as required. | Hierarchy name or names. |
HierarchiesOnRows | Sets hierarchies on rows. Will move hierarchies as required. | Hierarchy name or names. |
MemberProperties | Sets the selected member properties for a hierarchy. | See the Member Properties section for more details. |
MemberSelectionType | Sets the selection type of the members, for example, children, parents, descendants etc. | See the Member Selection Type section for more details. |
MergeRepeatingCells | Merge cells containing the same member in cross-joins. Applies to both MergeRepeatingRowCells and MergeRepeatingColumnCells at once. | TRUE or FALSE |
MergeRepeatingColumnCells | Merge cells containing the same member in column cross-joins. | TRUE or FALSE |
MergeRepeatingRowCells | Merge cells containing the same member in row cross-joins. | TRUE or FALSE |
RemoveEmptyColumns | Sets the columns to hide or show members with no data. | TRUE or FALSE |
RemoveEmptyRows | Sets the rows to hide or show members with no data. | TRUE or FALSE |
ShowDescendantComments | Toggle whether descendant comments should be shown, if Cube Comments are enabled for the Grid. | TRUE or FALSE |
Grid Permissions
Review Grid Permissions for details of what the options below do.
Property | Value |
ColumnMembers | TRUE or FALSE |
ColumnNavigation | TRUE or FALSE |
RowMembers | TRUE or FALSE |
RowNavigation | TRUE or FALSE |
DimensionNavigation | TRUE or FALSE |
Menus | TRUE or FALSE |
SlicerMembers | TRUE or FALSE |