Bug: Rounding Error on a number that isn't being rounded

#1

Whenever I type in 41.76 when on a percentage tab I get this instead.

#2

Can you use the format dialog to round it to two decimal places and see if that works for you.

#3

It does. But that’s more of a band-aid that doesn’t really solve the underlying issue of the number 41.76 being changed by Coda into the number 41.75999999999997. If we cannot trust that the numbers we input into the system are recognized wholly as the numbers we specify. How can we trust that especially large calculations aren’t off by potentially… orders of magnitude?

#4

I understand. It is a well known javascript floating point issue -
https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel

http://www.saintsatplay.com/blog/2014/08/handling-floating-point-numbers-in-javascript#.W7zY4BNKi3U

Let me talk to the team and see if there is anything we plan to do.

1 Like