SpreadJS Documentation
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.
Occurs when the user types a formula.
Syntax
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.
$("#spreadContainer").data("spread").getActiveSheet().bind(GcSpread.Sheets.Events.UserFormulaEntered, function (e, info) {    
        alert("Formula (" + info.formula + ")");
});
See Also

Reference

Events type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.