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

The cell element can be used in the following components:

• Sheet
• Workbook

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 columns   cellPosLengthY - Vertical length by rows cellPosX minimum: 0 cellPosY 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