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.
| JavaScript |  Copy Code |
|---|---|
<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> |
|