ColumnSummary

Allows making pre-defined calculations on the cell values and display the results within Handsontable.
See the demo for more information.

Example

const container = document.getElementById('example');
const hot = new Handsontable(container, {
data: getData(),
colHeaders: true,
rowHeaders: true,
columnSummary: [
{
destinationRow: 4,
destinationColumn: 1,
type: 'min'
},
{
destinationRow: 0,
destinationColumn: 3,
reversedRowCoords: true,
type: 'max'
},
{
destinationRow: 4,
destinationColumn: 5,
type: 'sum',
forceNumeric: true
}
]
});

Classes

ColumnSummary

Methods

disablePlugin()

Disables the plugin functionality for this Handsontable instance.

enablePlugin()

Enables the plugin functionality for this Handsontable instance.

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 than the ColumnSummary#enablePlugin method is called.

Returns: {boolean}
Class: ColumnSummary