Restrict number of decimal places to 2

Getting help Questions
1

Hello,

We still have some issues with our tables, in a earlier topic you respond with a jsfiddle in that the DEV column shows a lot of decimal places ( this seems to fix de red colored column ).

Here it is: https://jsfiddle.net/qwv3q1L1/

Is there a way to show only 2 decimal places? It seems that the calculation does not take into account the format at the time of showing it.

Thanks for your help!

2

Hi @carlos.duran.garcia

If you mean the cell with the e notation there’s one related issue https://github.com/handsontable/handsontable/issues/2030

3

We are checking de hansontable.full.js code and it seems the change we saw in that topic is already in ( don’t remmeber what version is it ) but is showing the red column.

Is there a fix for that issue? In the last message of that topic there is an example of the column in red color, just like it happens in our application.

At least, is there a way to minimize the decimals used in the sum calculation?

Note: The solution for the red column worked! There isn’t red colummn at all now, but it show the decimal number with e notation right in the table.

Thanks!

4

Thank you for an update. Please let me know if there is anything I can help you with.

5

Yeah, thanks for the help!

If i use your workaround and delete the type:“numeric” the column now show a lot of decimal places on e notation, the user don’t want this, as you see here the diference between Buget and Forecast is 0, but the dev column don’t show that.

If i put again the type, then i have a red color in column DEV.

So the question again is: How can i show the real diference of 0, if the calculation give me the amount of 0.000000001. If i could fix it to 2 decimal places the problem solves itself.

6

Thank you for the scenario. I have tried different approaches but did not find any workaround. Please track changes to https://github.com/handsontable/handsontable/issues/4353 for more details.

We will be rewriting the Formula Support plugin later this year (with a help of external team) that is why we are not fixing formula bugs now.

7

I track this out from now on.

Thank you for the help!!

8

You’re welcome