Class: Sheet

Sheet

Sheet component responsible for whole spreadsheet calculations.

Members

alterManagerAlterManager

Instance of AlterManager.

dataProviderDataProvider

Data provider for sheet calculations.

hotCore

Handsontable instance.

matrixMatrix

Instance of Matrix.

parserParser

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

Methods

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.

destroy()

Destroy class.

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}

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}

getVariable(name){*}

Get variable name.

Parameters:
Name Type Description
name String

Variable name.

Returns: {*}

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.

recalculate()

Recalculate sheet.

recalculateFull()

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

recalculateOptimized()

Recalculate sheet using optimized methods (fast recalculation).

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.