search

audreyt / ethercalc

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

SUMIFS #108

Closed EarlJS closed 10 years ago

EarlJS commented 10 years ago

Good day,

Wow, this is brilliant! I stumbled across Ethercalc a few hours ago, and have been tinkering away non stop. I am in awe (a few of us actually)

Is there any chance that SUMIFS could be implemented in Ethercalc at all?

Off to play some more!

Kind regards, Earl

audreyt commented 10 years ago

Hi, glad you like it!

SUMIF and COUNTIF is in https://github.com/audreyt/ethercalc/blob/master/formula1.js#L2616 (and registered in 2708) — Pull requests welcome to extend them to multi-arg variants.

The relevant spec is: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018586_715980110

EarlJS commented 10 years ago

Thank you Audrey!

Is there any way we could sponsor the development of this feature, and possibly several others? Would rather have it done properly, and since you know it better than any of us…

Kind regards,

Earl

From: 唐鳳 [mailto:notifications@github.com] Sent: 03 September 2014 11:44 To: audreyt/ethercalc Cc: EarlJS Subject: Re: [ethercalc] SUMIFS (#108)

Hi, glad you like it!

SUMIF and COUNTIF is in https://github.com/audreyt/ethercalc/blob/master/formula1.js#L2616 (and registered in 2708) — Pull requests welcome to extend them to multi-arg variants.

The relevant spec is: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018586_715980110

— Reply to this email directly or view it on GitHub https://github.com/audreyt/ethercalc/issues/108#issuecomment-54273631 . https://github.com/notifications/beacon/8633412__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyNTM1NjYyOCwiZGF0YSI6eyJpZCI6NDEzNDY1Nzh9fQ==--7be06d763507c16d793df27bfea575ff6ede79be.gif

audreyt commented 10 years ago

Well, I charge 1BTC/hr at 194m2VAsxudUyEzfzbAypN3WYuQ71BL4re for sponsored work.

If you'd like to use PayPal instead, my account is audreyt@audreyt.org.

If you have a list of desired features so we can group them into a single hour, feel free to post it here or to the email above.

audreyt commented 10 years ago

It looks like @recalcc has experience implementing https://github.com/sutoiku/formula.js integration, which would allow SUMIFS to be implemented cleanly as well. Perhaps they're amenable to sponsored work as well?

abiank commented 10 years ago

No, I doubt the formula.js route would work as it is -- as of now only functions that work on and return numbers and strings are functional. (no arrays & ranges yet) POC: https://gist.github.com/abiank/6b1a06e032ddaca395bb

audreyt commented 10 years ago

Hi @EarlJS, this is implemented as of 001c2779; there's also minimal test in misc/ for this feature as of 5de02284.