Evaluates the specified formula.
var value; // Type: object
value = GC.Spread.Sheets.CalcEngine.evaluateFormula(context, formula, baseRow, baseColumn, useR1C1);
function evaluateFormula(
: object,
: string,
: number,
baseColumn : number,
: 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.