Formulas

Members

columnAxisSyncer

Ask AI

Source code

formulas.columnAxisSyncer : AxisSyncer | null

Index synchronizer responsible for syncing the order of HOT and HF’s data for the axis of the columns.

engine

Ask AI

Source code

formulas.engine : HyperFormula | null

The engine instance that will be used for this instance of Handsontable.

indexSyncer

Ask AI

Source code

formulas.indexSyncer : IndexSyncer | null

Index synchronizer responsible for manipulating with some general options related to indexes synchronization.

rowAxisSyncer

Ask AI

Source code

formulas.rowAxisSyncer : AxisSyncer | null

Index synchronizer responsible for syncing the order of HOT and HF’s data for the axis of the rows.

sheetId

Ask AI

Source code

formulas.sheetId : number | null

HyperFormula’s sheet id.

sheetName

Ask AI

Source code

formulas.sheetName : string | null

HyperFormula’s sheet name.

Methods

addSheet

Ask AI

Source code

formulas.addSheet([sheetName], [sheetData]) ⇒ boolean | string

Add a sheet to the shared HyperFormula instance.

Param	Type	Description
[sheetName]	string null	optional The new sheet name. If not provided (or a null is passed), will be auto-generated by HyperFormula.
[sheetData]	Array	optional Data passed to the shared HyperFormula instance. Has to be declared as an array of arrays - array of objects is not supported in this scenario.

Returns: boolean | string - false if the data format is unusable or it is impossible to add a new sheet to the engine, the created sheet name otherwise.

destroy

Ask AI

Source code

formulas.destroy()

Destroys the plugin instance.

disablePlugin

Ask AI

Source code

formulas.disablePlugin()

Disables the plugin functionality for this Handsontable instance.

enablePlugin

Ask AI

Source code

formulas.enablePlugin()

Enables the plugin functionality for this Handsontable instance.

getCellType

Ask AI

Source code

formulas.getCellType(row, column, [sheet]) ⇒ string

Get the cell type under specified visual coordinates.

Param	Type	Description
row	number	Visual row index.
column	number	Visual column index.
[sheet]	number	optional The target sheet id, defaults to the current sheet.

Returns: string - Possible values: ‘FORMULA’ | ‘VALUE’ | ‘ARRAYFORMULA’ | ‘EMPTY’.

isEnabled

Ask AI

Source code

formulas.isEnabled() ⇒ boolean

Checks if the plugin is enabled in the handsontable settings. This method is executed in Hooks#beforeInit hook and if it returns true then the Formulas#enablePlugin method is called.

isFormulaCellType

Ask AI

Source code

formulas.isFormulaCellType(row, column, [sheet]) ⇒ boolean

Returns true if under specified visual coordinates is formula.

Param	Type	Description
row	number	Visual row index.
column	number	Visual column index.
[sheet]	number	optional The target sheet id, defaults to the current sheet.

switchSheet

Ask AI

Source code

formulas.switchSheet(sheetName)

Switch the sheet used as data in the Handsontable instance (it loads the data from the shared HyperFormula instance).

Param	Type	Description
sheetName	string	Sheet name used in the shared HyperFormula instance.