Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Client-Side Scripting Reference / Scripting Members / Events / ActiveCellChanging
In This Topic
    ActiveCellChanging
    In This Topic

    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