Hello!!!
Is posible to change precision of cells? I would like to calculate “formula” with four (4) decimals , for example:
var = 1,500.1234 * 2.2345 / 1.3456
result:
var = 2,491.1012
If i would like to change the number format to ###.###,#### , math formula will work fine? for example:
var = 1.500,1234 * 2,2345 / 1,3456
result:
var = 2.491,1012
thanks
Alex
If you are using pure math excells, the rounding can be set as
grid.setMathRound(4);
it will define the rounging for result of all math operation.
If you are using end|ron excell types - rounding can be set in default way ( by setNumberFormat(“0,000.000”) )
If you need store data with higher precision, than rendered in grid one - you can try to use next patch
dhtmlx.com/docs/products/kb/inde … =precision