SpreadJS 13
GC.Spread.Sheets Namespace / Events type / RangeChanged Event
The sheet that triggered the event.
The sheet's name.
The range's row index.
The range's column index.
The range's row count.
The range's column count.
A collection of table names.
The positions of the cells whose data has changed, each position has row and col.
The type of action that raises the RangeChanged event.
Whether this event is from a undo operation.
In This Topic
    RangeChanged Event
    In This Topic
    Occurs when the cell range has changed.
    Syntax
    var instance; // Type: Events
    instance.RangeChanged = function(sheet,
                                     sheetName,
                                     row,
                                     col,
                                     rowCount,
                                     colCount,
                                     tableNames,
                                     changedCells,
                                     action,
                                     isUndo) { };
    RangeChanged = function ( 
       sheet : Worksheet,
       sheetName : string,
       row : number,
       col : number,
       rowCount : number,
       colCount : number,
       tableNames : undefined,
       changedCells : undefined,
       action : RangeChangedAction,
       isUndo : boolean
    ) { };

    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.
    tableNames
    A collection of table names.
    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.
    isUndo
    Whether this event is from a undo operation.
    Example
    This example returns the sheet name and action when changing the cell range in Microsoft Internet Explorer.
    activeSheet.bind(GC.Spread.Sheets.Events.RangeChanged, function (sender, args) {
      console.log(args.sheetName, args.action);
    });
    See Also

    Reference

    Events type