I added the following constants+---+---+---+|   | A | B |+---+---+---+| 1 | 1 | 1 || 2 | 2 | 2 || 3 | 3 | 2 |+---+---+---+Then on C1 I wrote the following formula=A1:A3+B1:B3The result wasFormula results in range value: A1:A3On Google Sheets I could press Ctrl+Shift+Enter and it automatically puts the formula as argument of ArrayFormula function. On Excel it's required to first select the required area for the result, write the formula, and then press Ctrl+Shift+Enter.Does ethercalc.org supports arrays formulas? How are they used?ReferencesUsing arrays in Google Sheets Google Docs Editors HelpARRAYFORMULA Google Docs Editors HelpGuidelines and examples of array formulas Microsoft SupportNon-Scalar Evaluation (aka 'Array expressions') Oasis Open Document Part 2: Recalculated Formula (OpenFormula) Format
How to enter an array formula on ethercalc.org
ethercalc
COMMAND() or DSUM() are maybe the closest.But no, there is no arrayformula support yet. COMMAND() / COMMANDIF()These issue spreadsheet commands and can set cell values/colors. They can change anything on the sheet.e.g. http://sheet.cellmaster.com.au/command_exampleDSUM() etcThe database functions exist in ethercalc DAVERAGE(databaserange, fieldname, criteriarange) DCOUNT(databaserange, fieldname, criteriarange) DCOUNTA(databaserange, fieldname, criteriarange) DGET(databaserange, fieldname, criteriarange) DMAX(databaserange, fieldname, criteriarange) DMIN(databaserange, fieldname, criteriarange) DPRODUCT(databaserange, fieldname, criteriarange) DSTDEV(databaserange, fieldname, criteriarange) DSTDEVP(databaserange, fieldname, criteriarange) DSUM(databaserange, fieldname, criteriarange) DVAR(databaserange, fieldname, criteriarange) DVARP(databaserange, fieldname, criteriarange)ArrayFormula() docs https://support.google.com/docs/answer/3093275 or =sum*{1,2;3,4})