Skip to main content

afterValueChange

caution

The afterValueChange event has been deprecated in v4.3. The event will continue work, but you'd better apply a new approach:

spreadsheet.events.on("afterAction", (actionName, config) => {
if (actionName === "setCellValue") {
console.log(actionName, config);
}
});

For more details about the new concept, see Spreadsheet actions.

Description

Fires after the value of a cell changes

Usage

afterValueChange: (cell: string, value: string) => void;

Parameters

The callback of the event takes the following parameters:

  • cell - (required) the id of a cell
  • value - (required) the value of a cell

Example

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {
// config parameters
});
// subscribe on the "afterValueChange" event
spreadsheet.events.on("afterValueChange", function(cell, value){
console.log("Value of cell "+ spreadsheet.selection.getSelectedCell()+" has changed");
console.log(cell, value);
});

Related articles: Event handling