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.