Unknown error on column with formula

Tags: #<Tag:0x00007efc729fc548>
#1

Hello,

I have an issue with formulas in Handsontable with summary columns.

I have a column ( Column C ) whose content is a formula ( subtraction ) involving other 2 columns with amounts ( ColumnA and ColumnB), all of them not editable, and another column ( ColumnD ) with editable amounts. Those amounts are summed in ColumnA.

On other hand i have some row with data, being the first a summary row for the other ones.

The issue is, when i try to set the ColumnC by adjusting the amounts in ColumnD ( the only editable column ) in some point the ColumnC shows a red color like there is something wrong in the column. This happens when adjusting the amounts so there’s some amounts with decimals.

I have prepared a jsfiddle demo so you can see this issue: https://jsfiddle.net/Codyfire/k5mLxc94/

Thanks for your support!

#2

Hi @carlos.duran.garcia

sorry for keeping you waiting.

I do not know why I haven’t been notified about the comment. Have you already fixed the issue or find a workaround?

#3

No, it is not solved yet.

At first i thought it was something due to our apps, but in the example i prepared i saw it has the same problem. Is there something i can do to avoid that?

And there is another issue, if you paste that entire table in an Excel sheet it show strange looking numbers that aren’t showing in the Handsontable.

#4

Hi @carlos.duran.garcia
Can you share a screenshot of Excel with the ‘strange looking numbers’ tried to replicate it, but without any success.

#5

Here it is, i simply paste the example in this topic in some excel:

image.png729×224 4.04 KB

This only happens when the Dev column total is red.

I think is the same problem.

#6

Hi @carlos.duran.garcia

it looks like the issue is related to cell type. If we comment the type the result is different https://jsfiddle.net/qwv3q1L1/

#7