SpreadJS 13
GC.Spread.Sheets Namespace / Events type / UserFormulaEntered Event
The sheet that triggered the event.
The sheet's name.
The row index of the cell in which the user entered a formula.
The column index of the cell in which the user entered a formula.
The formula that the user entered.
In This Topic
    UserFormulaEntered Event
    In This Topic
    Occurs when the user types a formula.
    Syntax
    var instance; // Type: Events
    instance.UserFormulaEntered = function(sheet, sheetName, row, col, formula) { };
    UserFormulaEntered = function ( 
       sheet : Worksheet,
       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.
    activeSheet.bind(GC.Spread.Sheets.Events.UserFormulaEntered, function (e, info) {    
            alert("Formula (" + info.formula + ")");
    });
    See Also

    Reference

    Events type