[Possible bug] Excel formula sum doesn't work as expected (V 4.0.1)

[bruno.anjos]

Hello.

I'm using the sum excel formula for my summary row like this:

summaryData: [{ classe_comp:'Soma', summaryRow: true, pq_fn:{n_nao_determinados:'sum(C:C)', n_machos:'sum(D:D)', n_femeas:'sum(E:E)', n_indiferenciados:'sum(F:F)', peso_nao_determinados:'sum(G:G)', peso_machos:'sum(H:H)', peso_femeas:'sum(I:I)', peso_indiferenciados:'sum(J:J)',  }}],

However I've noticed that when I input certain numbers in the grid the sum goes crazy and instead gives me an approximate number (either above or below). I'll attached a printscreen showing the issue.

[paramvir]

That's an issue with the javascript calculations.

https://stackoverflow.com/questions/1458633/how-to-deal-with-floating-point-number-precision-in-javascript

To fix it, you can use column.format to round off the decimals.