SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setArrayFormula Method
The start row index.
The start column index.
The number of rows in range.
The number of columns in range.
The array formula to place in the specified range.
In This Topic
    setArrayFormula Method
    In This Topic
    Sets a formula in a specified cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setArrayFormula(row, col, rowCount, colCount, value);
    function setArrayFormula( 
       row : number,
       col : number,
       rowCount : number,
       colCount : number,
       value : string
    ) : any;

    Parameters

    row
    The start row index.
    col
    The start column index.
    rowCount
    The number of rows in range.
    colCount
    The number of columns in range.
    value
    The array formula to place in the specified range.
    Example
    This example uses the setArrayFormula method.
    activeSheet.getCell(1,1).value(3);
    activeSheet.getCell(2,1).value(1);
    activeSheet.getCell(3,1).value(3);
    activeSheet.getCell(4,1).value(7);
    activeSheet.getCell(1,2).value(7);
    activeSheet.getCell(2,2).value(7);
    activeSheet.getCell(3,2).value(7);
    activeSheet.getCell(4,2).value(7);
    spread.allowUserEditFormula(true);
    activeSheet.setArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5");
    See Also

    Reference

    Worksheet type