Spread.Sheets Documentation
evaluateFormula Method
The evaluation context; in general, you should use the active sheet object.
The formula string.
The base row index of the formula.
The base column index of the formula.
Whether to use the r1c1 reference style.
Evaluates the specified formula.
Syntax
var value; // Type: object
value = GC.Spread.Sheets.CalcEngine.evaluateFormula(context, formula, baseRow, baseColumn, useR1C1);
function evaluateFormula( 
   context : object,
   formula : string,
   baseRow : number,
   baseColumn : number,
   useR1C1 : boolean
) : object;

Parameters

context
The evaluation context; in general, you should use the active sheet object.
formula
The formula string.
baseRow
The base row index of the formula.
baseColumn
The base column index of the formula.
useR1C1
Whether to use the r1c1 reference style.

Return Value

The evaluated formula result.
See Also

Reference

CalcEngine type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.