Handson Table is throwing #VALUE Error on complex formula like =SUMIF

Tags: #<Tag:0x00007efc648afa68>
#1

I was trying to implement complex excel formula in hands on table, and am not able to get the result, but where as same formula is evaluated in Excel.

A simple sample is stated in below JS Fiddle.
https://jsfiddle.net/th6csvbr/

And also some of the formula expectations with handson table are as follows.

=IF($AA6=“No”,0,IF($AB6=0,$U6,IF($AB6="",$U6,IF(AND(($U6>=$AB6),($U6<=$AC6)),$U6,AVERAGE($AB6,$AC6)))))

=SUMIF($I$2:$I$6B204,“Relevant”,O2:O64)

And these kind of formulae will exists in most of the cells

#2

Hi @mshettyshanath

This issue is already reported on our Github board https://github.com/handsontable/handsontable/issues/6790

I will notify you once it is solved.

#3

Hi Thanks for the replay
when can we expect the release of own calculation engine by HandsonTable.

#4

Our roadmap is not yet finished but the formulas plugin is very important for us and should be ready soon.

#5

Thanks for the support

#6

We’re welcome. If you would need any help with Handsontable feel free to send me an email (support@handsontable.com).

1 Like
#7

This issue was solved in v.9.0.0.

#8