spill
Implementations
Microsoft Excel: AIDCT.spill(array, maximumHeight, maximumWidth)
Google Sheets: Google Sheets: aidctSpill(array, maximumHeight, maximumWidth)
Spill a one-dimensional matrix to fit a rectangle within a given maximum height and width.
This function returns an array of values if the array parameter is a single value or a matrix of values if the array parameter is an array of values.
Parameters
| Name | Type | Description |
|---|---|---|
| array* | Any | Array to spill. |
| maximumHeight | Number | Maximum height into which to spill the array. If not provided, the remaining sheet height is used. |
| maximumWidth | Number | Maximum width into which to spill the array. If not provided, the remaining sheet width is used. |
Parameters in italics are optional.
* This parameter accepts a single value or an array of values.