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 onActiveCellChanging = "handler" ...>

[Event Property]

FpSpread1.onActiveCellChanging = handler

[Named Script]

<SCRIPT FOR=FpSpread1 EVENT=onActiveCellChanging>

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.

<script language="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() {
      var r = event.row;
      var c = event.col;
      if (r==1) event.cancel = true;
    }
</SCRIPT>

Copyright © GrapeCity, inc. All rights reserved.