Members

staticCellValue.STATE_COMPUTING

Computing state indicates cells under processing.

staticCellValue.STATE_OUT_OFF_DATE

Out of date state indicates cells ready for recomputing.

staticCellValue.STATE_UP_TO_DATE

Up to date state indicates cells with fresh computed value.

errorstring null

Error name.

precedentsArray

List of precedents cells.

statestring

Indicates cell state.

value*

Computed value.

Methods

Source code

addPrecedent(cellReference)

Add precedent cell to the collection.

Parameters:

Name	Type	Description
cellReference	CellReference	Cell reference object.

Source code

clearPrecedents()

Clear all precedent cells.

Source code

getError(){string|null}

Get error name for this cell.

Returns: {string|null}

Source code

getPrecedents(){Array}

Get precedent cells.

Returns: {Array}

Source code

getValue(){*}

Get computed value.

Returns: {*}

Source code

hasError(){boolean}

Check if cell value is marked as error.

Returns: {boolean}

Source code

hasPrecedent(cellReference){boolean}

Check if cell reference is precedents this cell.

Parameters:

Name	Type	Description
cellReference	CellReference	Cell reference object.

Returns: {boolean}

Source code

hasPrecedents(){boolean}

Check if cell value has precedents cells.

Returns: {boolean}

Source code

isState(state){boolean}

Check cell state.

Parameters:

Name	Type	Description
state	number	The state to compare with.

Returns: {boolean}

Source code

removePrecedent(cellReference)

Remove precedent cell from the collection.

Parameters:

Name	Type	Description
cellReference	CellReference	Cell reference object.

Source code

setError(error)

Set error message for this cell.

Parameters:

Name	Type	Description
error	string	Error name.

Source code

setState(state)

Set cell state.

Parameters:

Name	Type	Description
state	number	Cell state.

Source code

setValue(value)

Set computed value.

Parameters:

Name	Type	Description
value	*	The calculated formula value.