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.