Spread.Sheets Documentation
formulaToExpression Method
The 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.
Parse the specified formula to expression tree.
Syntax
var value; // Type: Expression
value = GC.Spread.Sheets.CalcEngine.formulaToExpression(context, formula, baseRow, baseColumn, useR1C1);
function formulaToExpression( 
   context : object,
   formula : string,
   baseRow : number,
   baseColumn : number,
   useR1C1 : boolean
) : Expression;

Parameters

context
The 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 expression tree.
See Also

Reference

CalcEngine type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.