Class: Formulas

Formulas

The formulas plugin.

handsontable-pro/src/plugins/formulas/formulas.js, line 18

Members

dataProviderDataProvider

Instance of DataProvider.

eventManagerEventManager

Instance of EventManager.

sheetSheet

Instance of Sheet.

undoRedoSnapshotUndoRedoSnapshot

Instance of UndoRedoSnapshot.

Methods

handsontable-pro/src/plugins/formulas/formulas.js, line 410

destroy()

Destroy plugin.

handsontable-pro/src/plugins/formulas/formulas.js, line 105

disablePlugin()

Disable plugin for this Handsontable instance.

handsontable-pro/src/plugins/formulas/formulas.js, line 68

enablePlugin()

Enable plugin for this Handsontable instance.

handsontable-pro/src/plugins/formulas/formulas.js, line 116

getCellValue(row, column){*}

Get cell value (evaluated from formula expression) at specified cell coords.

Parameters:
Name Type Description
row Number

Row index.

column Number

Column index.

Returns: {*}
handsontable-pro/src/plugins/formulas/formulas.js, line 170

getVariable(name){*}

Get variable name.

Parameters:
Name Type Description
name String

Variable name.

Returns: {*}
handsontable-pro/src/plugins/formulas/formulas.js, line 129

hasComputedCellValue(row, column){Boolean}

Check if there are any formula evaluations made under specific cell coords.

Parameters:
Name Type Description
row Number

Row index.

column Number

Column index.

Returns: {Boolean}
handsontable-pro/src/plugins/formulas/formulas.js, line 60

isEnabled(){Boolean}

Check if the plugin is enabled in the Handsontable settings.

Returns: {Boolean}
handsontable-pro/src/plugins/formulas/formulas.js, line 136

recalculate()

Recalculate all formulas (an algorithm will choose the best method of calculation).

handsontable-pro/src/plugins/formulas/formulas.js, line 143

recalculateFull()

Recalculate all formulas (rebuild dependencies from scratch - slow approach).

handsontable-pro/src/plugins/formulas/formulas.js, line 150

recalculateOptimized()

Recalculate all formulas (recalculate only changed cells - fast approach).

handsontable-pro/src/plugins/formulas/formulas.js, line 160

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.