How to enter an array formula on ethercalc.org

Question

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:B3

The result was

Formula results in range value: A1:A3

On 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?

References

• Using arrays in Google Sheets Google Docs Editors Help
• ARRAYFORMULA Google Docs Editors Help
• Guidelines and examples of array formulas Microsoft Support
• Non-Scalar Evaluation (aka 'Array expressions') Oasis Open Document Part 2: Recalculated Formula (OpenFormula) Format

Answer 1

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_example

• DSUM() etc

  The 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})

Answer 2

Short answer

At this time ethercalc.org doesn't handle array formulas like Excel or Google Sheets do but it has other functions like COPYVALUES, COPYFORMULAS, INSERT among others that could be used instead.

Extended answer

From a comment by eddiparkinson

For examples of COPYVALUES see B67, for INSERT see B65 in http://sheet.cellmaster.com.au/carbonoffset/appeditor

From userguide?, notes mine:

1. where can I find the list of the functions (sqrt, sin, sum, ...) accepted by ethercalc?
2. what is a waflphrase supposed to represent?
3. {...} Is it correct to say that certain formatting tags apply only to multi-line texts? Such as ol, ul, .pre? Those with \n in their source code's regexps?

---

1. SocialCalc.Formula.FunctionList — type that in the JS console of a running EtherCalc instance to get the full list. They are defined in https://github.com/audreyt/ethercalc/blob/master/formula1.js¹ and the spec is OpenFormula: https://en.wikipedia.org/wiki/OpenFormula
2. It's something like a Macro in the Socialtext system; currently EtherCalc does not implement WAFL expansion functionality.
3. Correct.

Notes: ¹: The formula1.js file was removed from audreyt/ethecarlc/master. It's available on other branches but on answer by eddyparkingson refers to https://github.com/marcelklehr/socialcalc

Ethercalc function guide

Fx toolbar button - the button on the spreadsheet toolbar gives a list of Ethercalc functions with descriptions.

Ethercalc functions

Google spreadsheet with the list of functions returned by typing SocialCalc.Formula.FunctionList on the browser console while having a Ethercalc.org sheet open. There are 136 functions, those that I identified that are not included in the OpenFormula spec are bolded. Note that the functions that returns arrays like TRANSPOSE, OFFSET, MMULT, etc. are not included.