UserFormulaEntered Event

Occurs when the user types a formula.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.UserFormulaEntered = function(sheet, sheetName, row, col, formula) { };

UserFormulaEntered = function ( 
   sheet : Sheet,
   sheetName : string,
   row : number,
   col : number,
   formula : string
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
row: The row index of the cell in which the user entered a formula.
col: The column index of the cell in which the user entered a formula.
formula: The formula that the user entered.

Example

This example uses the UserFormulaEntered event.

Javascript

$("#spreadContainer").data("spread").getActiveSheet().bind(GcSpread.Sheets.Events.UserFormulaEntered, function (e, info) {    
        alert("Formula (" + info.formula + ")");
});

Reference

Events type