SpreadJS 13
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.
In This Topic
    formulaToRanges Method
    In This Topic
    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