Spread.Sheets Documentation
Creating an Array Formula
Spread.Sheets Documentation > Developer's Guide > Managing the User Interface > Using Formulas > Creating an Array Formula

Spread.Sheets 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