onActiveCellChanged

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

Syntax

[Inline HTML]

[Event Property]

FpSpread1.onActiveCellChanged = handler

[Named Script]

Arguments

event.row: Row index of new active cell
event.col: Column index of new active cell
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 new indexes of the new active cell.

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("ActiveCellChanged", cellChanged, false); } else { // Other versions of IE and IE9 quirks mode (no doctype set) spread1.onActiveCellChanged = cellChanged; } } else { // Firefox spread1.addEventListener("ActiveCellChanged", cellChanged, false); } } function cellChanged(event) { alert("r"+event.row+",c"+event.col); } </script>

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("ActiveCellChanged", cellChanged, false);
                } else {
                    // Other versions of IE and IE9 quirks mode (no doctype set)
                    spread1.onActiveCellChanged = cellChanged;
                }
            }
            else {
                // Firefox
                spread1.addEventListener("ActiveCellChanged", cellChanged, false);
            }
        }
    
        function cellChanged(event) {
            alert("r"+event.row+",c"+event.col);
        }
</script>