SpreadJS Documentation
formulaToRanges Method
GC.Spread.Sheets Namespace > CalcEngine type : formulaToRanges Method
The base sheet.
The formula.
The base row index of the formula.
The base column index of the formula.
Converts a formula string to the specified cell ranges.
Syntax
var value; // Type: Array
value = GC.Spread.Sheets.CalcEngine.formulaToRanges(sheet, formula, baseRow, baseCol);
function formulaToRanges( 
   sheet : Worksheet,
   formula : string,
   baseRow : number,
   baseCol : number
) : Array;

Parameters

sheet
The base sheet.
formula
The formula.
baseRow
The base row index of the formula.
baseCol
The base column index of the formula.

Return Value

The cell ranges that refers to the formula string.
Example


Remarks

See Also

Reference

CalcEngine type

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page