2

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

2
2

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

2
  • The database functions are similar to SUM, AVERAGE, and other functions that allows a range as argument, but returns a Number. What I'm looking for is functions and/or formula notation to return an array. I'll try COPYFORMULA / COPYVALUES – Rubén Nov 25 '16 at 15:30
  • 1
    For examples of COPYVALUES see B67, for INSERT see B65 in sheet.cellmaster.com.au/carbonoffset/appeditor – eddyparkinson Nov 26 '16 at 0:39
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.js1 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: 1: 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.