Spread for ASP.NET 12 Product Documentation
ActiveCellChanging
Spread for ASP.NET 12 Product Documentation > Client-Side Scripting Reference > Scripting Members > Events > ActiveCellChanging

Occurs when the active cell is changing from the current one to a new one (when the user clicks a new cell).

Syntax

[Inline HTML]

<ELEMENT ActiveCellChanging = "handler" ...>

[JavaScript]

FpSpread1.addEventListener("ActiveCellChanging", handler, ...)

or

FpSpread1.onActiveCellChanging = handler

Arguments

event.row
Row index of new active cell
event.col
Column index of new active cell
event.cancel
Whether to cancel the operation
event.spread
Spread that raises the event

Return Type

None

Remarks

This event is triggered when the user changes from one cell to another. The event uses as arguments the indexes of the row and column of the new active cell.

If the cancel argument is set to true, the event is canceled and the active cell is not changed.

Example

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

JavaScript
Copy Code
<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("ActiveCellChanging", cellChanging, false);
      } else {
      // Other versions of IE and IE9 quirks mode (no doctype set)
      spread1.onActiveCellChanging = cellChanging;
      }
      }
      else {
      // Firefox
      spread1.addEventListener("ActiveCellChanging", cellChanging, false);
      }
      }
    
    function cellChanging(event) {
      var r = event.row;
      var c = event.col;
      if (r==1) event.cancel = true;
    }
</script>
See Also