Class: Sheet

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.

tRecordTranslator

Record translator for translating visual records into psychical and vice versa.

Methods

handsontable-pro/src/plugins/formulas/sheet.js, line 162

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.

handsontable-pro/src/plugins/formulas/sheet.js, line 330

destroy()

Destroy class.

handsontable-pro/src/plugins/formulas/sheet.js, line 214

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}

handsontable-pro/src/plugins/formulas/sheet.js, line 225

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}

handsontable-pro/src/plugins/formulas/sheet.js, line 151

getVariable(name){*}

Get variable name.

Parameters:

Name	Type	Description
name	String	Variable name.

Returns: {*}

handsontable-pro/src/plugins/formulas/sheet.js, line 188

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.

handsontable-pro/src/plugins/formulas/sheet.js, line 84

recalculate()

Recalculate sheet.

handsontable-pro/src/plugins/formulas/sheet.js, line 118

recalculateFull()

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

handsontable-pro/src/plugins/formulas/sheet.js, line 100

recalculateOptimized()

Recalculate sheet using optimized methods (fast recalculation).

handsontable-pro/src/plugins/formulas/sheet.js, line 141

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.