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 |