Precision inside Math Cells (grid)

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