Members

alterManagerAlterManager

Instance of AlterManager.

dataProviderDataProvider

Data provider for sheet calculations.

hotCore

Handsontable instance.

matrixMatrix

Instance of Matrix.

parserParser

Instance of https://github.com/handsontable/formula-parser.

Methods

Source code

applyChanges(row, column, newValue)

Apply changes to the sheet.

Parameters:

Name	Type	Description
row	number	Physical row index.
column	number	Physical column index.
newValue	*	Current cell value.

Source code

destroy()

Destroy class.

Source code

getCellAt(row, column){CellValue|undefined}

Get cell value object at specified physical coordinates.

Parameters:

Name	Type	Description
row	number	Physical row index.
column	number	Physical column index.

Returns: {CellValue|undefined}

Source code

getCellDependencies(row, column){Array}

Get cell dependencies at specified physical coordinates.

Parameters:

Name	Type	Description
row	number	Physical row index.
column	number	Physical column index.

Returns: {Array}

Source code

getVariable(name){*}

Get variable name.

Parameters:

Name	Type	Description
name	string	Variable name.

Returns: {*}

Source code

parseExpression(cellValue, formula)

Parse and evaluate formula for provided cell.

Parameters:

Name	Type	Description
cellValue	CellValue | object	Cell value object.
formula	string	Value to evaluate.

Source code

recalculate()

Recalculate sheet.

Source code

recalculateFull()

Recalculate whole table by building dependencies from scratch (slow recalculation).

Source code

recalculateOptimized()

Recalculate sheet using optimized methods (fast recalculation).

Source code

setVariable(name, value)

Set predefined variable name which can be visible while parsing formula expression.

Parameters:

Name	Type	Description
name	string	Variable name.
value	*	Variable value.