var value; // Type: object
value = GcSpread.Sheets.Calc.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

Reference

Calc type