search

audreyt / ethercalc

Node.js port of Multi-user SocialCalc
https://ethercalc.net
Other
2.97k stars 537 forks source link

Excel style range Intersection - feature request #473

Open slacie opened 7 years ago

slacie commented 7 years ago

Hello! I tryed formula that works in excel but not in ethercalc: =SUM(A1:D4 B2:C5) Try that in excel and here

eddyparkinson commented 7 years ago

looks to be missing a comma. Try:

=SUM(A1:D4,B2:C5)

http://sheet.cellmaster.com.au/examples_sum

Let me know if this works. Closing the issue.

slacie commented 7 years ago

It is not missing a comma @eddyparkinson do you have a copy of excel with you? =SUM(A1:D4 B2:C5) with a space no comma means range intersection. If you have never used excel, https://support.office.com/en-us/article/Calculation-operators-and-precedence-in-Excel-48be406d-4975-4d31-b2b8-7af9e0e2878a explains all of the operators

eddyparkinson commented 7 years ago

Looks to be supported by excel, but not google or ods

https://productforums.google.com/forum/#!topic/docs/nyuIihxI62U;context-place=topicsearchin/docs/authorid$3AAPn2wQemgBZ9VMCaCkOt4wt7kwB7GNPonmqiOHe7uiK34KFtpgzk9ZRYvWo9NoN6D7TboQdAXfTa%7Csort:date%7Cspell:false

Pull requests welcome Related code section: https://github.com/marcelklehr/socialcalc/blob/master/formula1.js#L152