The XL3SetProperty formula updates Anaplan XL Reporting objects in the workbook.
You can update objects as grids, slicers, and dynamic charts (Small multiple charts). You can use this to update settings from the properties screen or move hierarchies.
Syntax
XL3SetProperty( ObjectType, ObjectName, Property, Arg1, [Arg2],…, [Arg27] )
Parameters
| Parameter | Description |
| ObjectType | Object Type to update. Valid values are Workbook, Grid, Slicer, Table, SmallMultiple, "Chart", "Map", "Pager" and "Range". |
| ObjectName | Name of the object to update. You can't update an object unless you have given it a name in its properties screen. |
| Property | Name of the property to update. Valid names depend on the object type. Details for each are below. |
| Arg1, [Arg2],…, [Arg27] | Value or values to set the property to. Valid values depend on the object type. Details for each are below. |
