Spread.Sheets 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 the specified cell range to a formula string.
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.
See Also

Reference

CalcEngine type

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page