RangeChanged Event

Occurs when the cell range has changed.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.RangeChanged = function(sheet, sheetName, row, column, rowCount, columnCount, changedCells, action) { };

RangeChanged = function ( 
   sheet : Sheet,
   sheetName : string,
   row : number,
   column : number,
   rowCount : number,
   columnCount : number,
   changedCells : Array,
   action : RangeChangedAction
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
row: The range's row index.
column: The range's column index.
rowCount: The range's row count.
columnCount: The range's column count.
changedCells: The positions of the cells whose data has changed.
action: The type of action that raises the RangeChanged event.

Example

This example returns the sheet name and action when changing the cell range in Microsoft Internet Explorer.

Javascript

spread.bind(GcSpread.Sheets.Events.RangeChanged, function (sender, args) {
  console.log(args.sheetName, args.action);
});

Reference

Events type