BeforeFormatChange

fires before the format of a cell is changed

boolean BeforeFormatChange(string cell,string format){ ... };

Parameters

cellstringthe id of a cell
formatstringa new format applied for a cell

Returns

booleantrue to change the format, false to prevent changing of the format

Example

spreadsheet.events.on("BeforeFormatChange", function(cell, format){
 console.log("Format of cell "+spreadsheet.selection.getSelectedCell()+" will change");
});

Related samples

Details

The event is blockable. Return false to cancel changing of the format.

See also
Back to top