RangeChanged Event

Occurs when the cell range has changed.

Syntax

Javascript (Usage)
Javascript (Specification)

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

RangeChanged = function ( 
   sheet : Worksheet,
   sheetName : string,
   row : number,
   col : number,
   rowCount : number,
   colCount : number,
   changedCells : undefined,
   action : RangeChangedAction
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
row: The range's row index.
col: The range's column index.
rowCount: The range's row count.
colCount: The range's column count.
changedCells: The positions of the cells whose data has changed, each position has row and col.
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

activeSheet.bind(GC.Spread.Sheets.Events.RangeChanged, function (sender, args) {
  console.log(args.sheetName, args.action);
});

Reference

Events type