SetDimensions
The SetDimensions() function sets the widths and heights of cells within a block of cells at a specified starting point.
Syntax
SetDimension ()
| Range | The starting cell of the block for which to set dimensions |
| Widths | Array of widths |
| Heights | Array of heights |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example – Setting the width and height dimensions of cells in a block of cells
In this example, the dimensions are set for a block of cells starting from A3, for four columns and three rows. Note: The name of the sheet needs to be specified, as the SetDimensions function may reside in a different worksheet from the cells for which dimensions are being set.
| Target block of cells | Set the dimensions | ||||
| =SetDimensions(“Sheet1!A3″,”3,15,5,3″,”30,15,20”) | |||||
| Target block with dimensions set | Result | ||||
| TRUE | |||||