Class: DataProvider

DataProvider

handsontable-pro/src/plugins/formulas/dataProvider.js, line 7

Data class provider responsible for providing a set of range data types, necessary for calculating formulas.
Those methods strongly using hot.getData and hot.getSourceData methods with some changes. Data provider additionally
collects all changes added to the data source to make them available faster than by using
hot.getData and hot.getSourceData methods.

Members

changesObject

Collected changes applied into editors or by calling public Handsontable API. This is require to provide
fresh data applied into spreadsheet before they will be available from the public API.

hotCore

Handsontable instance.

hotCore

Handsontable instance.

optionsObject

Format type class options.

tRecordTranslator

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

Methods

handsontable-pro/src/plugins/formulas/dataProvider.js, line 53

clearChanges()

Clear all collected changes.

handsontable-pro/src/plugins/formulas/dataProvider.js, line 46

collectChanges(row, column, value)

Collect all data changes applied to the Handsontable to make them available later.

Parameters:
Name Type Description
row Number

Physical row index.
column Number

Physical column index.
value *

Value to store.
handsontable-pro/src/plugins/formulas/dataProvider.js, line 215

destroy()

Destroy class.

handsontable-pro/src/plugins/exportFile/dataProvider.js, line 94

getColumnHeaders(){Array}

Gets list of columns headers.

Returns: {Array}
handsontable-pro/src/plugins/exportFile/dataProvider.js, line 42

getData(){Array}

Get table data based on provided settings to the class constructor.

Returns: {Array}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 75

getDataAtCell(visualRow, visualColumn){*}

Get calculated data at specified cell.

Parameters:
Name Type Description
visualRow Number

Visual row index.
visualColumn Number

Visual column index.
Returns: {*}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 97

getDataByRange(visualRow1, visualColumn1, visualRow2, visualColumn2){Array}

Get calculated data at specified range.

Parameters:
Name Type Description
visualRow1 Number optional

Visual row index.
visualColumn1 Number optional

Visual column index.
visualRow2 Number optional

Visual row index.
visualColumn2 Number optional

Visual column index.
Returns: {Array}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 153

getRawDataAtCell(visualRow, visualColumn){*}

Get source data at specified visual cell.

Parameters:
Name Type Description
visualRow Number

Visual row index.
visualColumn Number

Visual column index.
Returns: {*}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 166

getRawDataByRange(visualRow1, visualColumn1, visualRow2, visualColumn2){Array}

Get source data at specified visual range.

Parameters:
Name Type Description
visualRow1 Number optional

Visual row index.
visualColumn1 Number optional

Visual column index.
visualRow2 Number optional

Visual row index.
visualColumn2 Number optional

Visual column index.
Returns: {Array}
handsontable-pro/src/plugins/exportFile/dataProvider.js, line 71

getRowHeaders(){Array}

Gets list of row headers.

Returns: {Array}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 120

getSourceDataAtCell(physicalRow, physicalColumn){*}

Get source data at specified physical cell.

Parameters:
Name Type Description
physicalRow Number

Physical row index.
physicalColumn Number

Physical column index.
Returns: {*}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 142

getSourceDataByRange(physicalRow1, physicalColumn1, physicalRow2, physicalColumn2){Array}

Get source data at specified physical range.

Parameters:
Name Type Description
physicalRow1 Number optional

Physical row index.
physicalColumn1 Number optional

Physical column index.
physicalRow2 Number optional

Physical row index.
physicalColumn2 Number optional

Physical column index.
Returns: {Array}
handsontable-pro/src/plugins/formulas/dataProvider.js, line 64

isInDataRange(visualRow, visualColumn){Boolean}

Check if provided coordinates match to the table range data.

Parameters:
Name Type Description
visualRow Number

Visual row index.
visualColumn Number

Visual row index.
Returns: {Boolean}
handsontable-pro/src/plugins/exportFile/dataProvider.js, line 33

setOptions(options)

Set options for data provider.

Parameters:
Name Type Description
options Object

Object with specified options.
handsontable-pro/src/plugins/formulas/dataProvider.js, line 196

updateSourceData(physicalRow, physicalColumn, value)

Update source data.

Parameters:
Name Type Description
physicalRow Number

Physical row index.
physicalColumn Number

Physical row index.
value *

Value to update.