SETSLICEOBJECTPROPERTIES
This function sets any property of a slice object definition.
Syntax
=SETSLICEOBJECTPROPERTIES("slice_object_definition","property_name"(expanding),property_value)
The function returns modified slice object about the property EXPANDING.
The EXPANDING property controls if the slice is expandable or not.
Example
In this example, B9 cell contains the result from CREATESLICEDEFINITION function:
=SETSLICEOBJECTPROPERTIES(B9,"expanding",TRUE)