Cell
Define the content, look, dimensions and place of a single cell. Must be placed with cell.pos.
Examples
{
"pos": [0,0,5,2],
"picture": {
"ref": "logo",
"width": 227,
"height": 60,
"position": "move"
}
}
Example: Cell spanning 5 columns and 2 rows on top of sheet with picture as content.
{
"pos": [3,1],
"format": {
"borderColor": "blue"
},
"value": 42
}
Example: Cell in third column, second row with blue border and integer value.
Implementations
Properties
name | type | description |
---|---|---|
height | integer | Height of the cell in pixel. |
width | integer | Width of the cell in pixel. |
pos | array | An array of integers describing the cell positioning. default length: 1 maxItems: 4 minItems: 2 Array Items: cellPosX - Horizontal position by columns. (Required)cellPosY - Vertical position by rows (Required)cellPosLengthX - Horizontal length by columnscellPosLengthY - Vertical length by rowscellPosX minimum: 0cellPosY minimum: 0 |
format | object | Format Options Format |
formatRef | string | Reference to a named format. |
value | string | Set cell value. |
integer | ||
boolean | ||
valueRef | string | Reference to central value storage. |
case | object | Conditional Properties Case |
array | ||
picture | object | A picture as content of a cell Picture |