Skip to main content
  Friday, September 25 2015
  5 Replies
  3K Visits
  Subscribe
Does your table support calculation such as this example: =IF(COUNT(B2:B23)<5,SUM(B2:B23),(SUMPRODUCT(LARGE(B2:B23,ROW(1:5)))))
T
Hi,

Nope, the calculation available yet are: SUM COUNT CONCAT MIN MAX AVG
And we've planned to include the following ones in a future version: http://handsontable.github.io/ruleJS/

Cheers,
Z
8 years ago
Hi Tristan,

what kind of formulas are about to come for Droptables and when do you plan to implement them? The link you provided above doesn't work for me.
I'm looking for an extension to do spreadsheets for invoice purposes. So simple calculation operators would be really useful for me.

Greetings
T
Hi,

- Droptables have some inbuilt calculations: SUM COUNT CONCAT MIN MAX AVG
We may add in the future: http://handsontable.github.io/ruleJS/

Cheers,
Z
7 years ago
Hello again.
Long time no see.
Are there more advanced calculations integrated in Droptables in the new version? Other than the one you mentioned above?
Also will they be imported/exported to excel?

Cheers.
T
Hi,

Yes indeed we have a large feature planning :) As you may have seen we just added the Excel and Google Sheets sync.
The next step will be a frontend template for edition then tables from database.

The calculation are planned after that :)

Also will they be imported/exported to excel

Not sure we have to check that.

Cheers,
  • Page :
  • 1
There are no replies made for this post yet.