Occurs when the user changes the value of a cell.

Syntax

[Inline HTML]

<ELEMENT onDataChanged = "handler" ...>

[Event Property]

FpSpread1.onDataChanged = handler

[Named Script]

<SCRIPT FOR=FpSpread1 EVENT=onDataChanged>

Arguments

event.cell

Cell whose value changed

event.row

Row index of cell

event.col

Column index of cell

event.cellValue

New value for the cell

event.spread

Spread that raises the event

Return Type

None

Remarks

This event is triggered when the user changes the value of a cell. The event uses as arguments the cell and its new value.

Example

This example JavaScript code maps the event for the Spread on the client side.

<script lang="javascript" type="text/javascript">
    window.onload = function () {
      var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
      if (document.all) {
        // IE
if (spread1.addEventListener) {
// IE9
spread1.addEventListener("DataChanged", dataChanged, false);
} else {
// Other versions of IE and IE9 quirks mode (no doctype set)
spread1.onDataChanged = dataChanged;
}
}
else {
// Firefox
spread1.addEventListener("DataChanged", dataChanged, false);
      }
    }
    
    function dataChanged(event) {
      alert("The data changed!");
    }
    
</script>

Copyright © GrapeCity, inc. All rights reserved.