| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SetProperty"
(Created page with 'This function updates XLCubed objects in the workbook such as grids, slicers and small multiples. You can use this to update some setting from the properties screen or move hier…') |
|||
| Line 13: | Line 13: | ||
|- | |- | ||
| {{Code|ObjectType}} | | {{Code|ObjectType}} | ||
| − | | Object Type to update. Valid values are " | + | | Object Type to update. Valid values are "workbook", "grid", "slicer" and "smallmultiple". |
|- | |- | ||
| {{Code|ObjectName}} | | {{Code|ObjectName}} | ||
| Line 23: | Line 23: | ||
| {{Code|Arg1, [Arg2],…, [Arg27]}} | | {{Code|Arg1, [Arg2],…, [Arg27]}} | ||
| Value or values to set the property to. Valid values depend on the object type. Details for each are below. | | Value or values to set the property to. Valid values depend on the object type. Details for each are below. | ||
| + | |} | ||
| + | |||
| + | ==Workbook== | ||
| + | {| class="wikitable" | ||
| + | ! Object Name | ||
| + | ! Property | ||
| + | ! Value | ||
| + | |- | ||
| + | | "Writeback" | ||
| + | | "SpreadMethod" | ||
| + | | Sets the formula spread method. Valid values are "USE_EQUAL_ALLOCATION", "USE_EQUAL_INCREMENT", "USE_WEIGHTED_ALLOCATION", "USE_WEIGHTED_INCREMENT" | ||
|} | |} | ||
Revision as of 10:24, 24 March 2011
This function updates XLCubed objects in the workbook such as grids, slicers and small multiples.
You can use this to update some setting from the properties screen or move hierarchies.
Contents
[hide]Syntax
XL3SetProperty( ObjectType, ObjectName, Property, Arg1, [Arg2],…, [Arg27] )
Parameters
| Parameter | Description |
|---|---|
| ObjectType | Object Type to update. Valid values are "workbook", "grid", "slicer" and "smallmultiple". |
| ObjectName | Name of the object to update. You can not 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. |
Workbook
| Object Name | Property | Value |
|---|---|---|
| "Writeback" | "SpreadMethod" | Sets the formula spread method. Valid values are "USE_EQUAL_ALLOCATION", "USE_EQUAL_INCREMENT", "USE_WEIGHTED_ALLOCATION", "USE_WEIGHTED_INCREMENT" |
