SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage User Interface / Formulas / Array Formulas
In This Topic
    Array Formulas
    In This Topic

    SpreadJS supports array formulas.

    Use Ctrl + Shift + Enter to create an array formula after entering the formula at run time if the users are allowed to create formulas, or you can use the setArrayFormula method.

    Array formulas are supported when exporting or importing to Excel-formatted files and JSON objects.

    Array formulas have the following limitations:

    Using Code

    This example uses the setArrayFormula method.

    JavaScript
    Copy Code
    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.options.allowUserEditFormula = true;
    activeSheet.setArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5");
    
    See Also

    Formula Reference