BeforeValueChange

fires before the values of cells change

boolean BeforeValueChange(string cells,string|number|array value){ ... };

Parameters

cellsstringthe id(s) of a cell(s)
valuestring|number|arraythe value(s) of a cell(s)

Returns

booleantrue to change the value(s) of a cell(s), false to prevent changing of value(s)

Example

spreadsheet.events.on("BeforeValueChange", function(cell,value){
 console.log("Value of cell "+ spreadsheet.selection.getSelectedCell()+" will change");
 return true;
});

Details

The event is blockable, returning false will prevent changing of value(s).

See also
Back to top