Is it possible to round numeric values?

Tags: #<Tag:0x00007f8b1df71520>
#1

Hi Aleksandra,

I’m working with Handsontable since 2 weeks now. This is a great tool.
But it seems I cant round my numeric values.

I have this value: 9.999999
I would like to display it like this: 10

There’s an exemple:
https://jsfiddle.net/q3n6cz1y/
As you can see, I try different formats / patterns of numbrojs.

The {pattern: ‘0,00.00’} is on the good way: it displays: 10.00 But there’s still .00
I would like to use {pattern: ‘0,00’} to display it like this: 10

The point is: I can’t modify the values in my dataset.

Is there a way to do it ?

(This is version 1.14 but values are perfectly rounded. This is what I would like to display)
https://jsfiddle.net/ywqrce47/

Thanks !

#2

Hey @jules.vautier

you can use native methods inside a custom renderer that runs your cells, here https://jsfiddle.net/jg3p74bs/ is an example

#3