SpreadJS Documentation
Creating an Array Formula

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

Formula Reference

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.