Is this a bug or I am doing something wrong?
When writing on it to type shows normal, when clicking out the ending changes, when clicking again shows normal again, happens on 3 last digits when having 18 digits
Is an editable number column, no decimals, no formula
646015206853256596
Typing:
After typing:
1 Like
this looks like coda is using floating point numbers behind the scenes to store its numbers.
so the precision is limited by the size of the mantisa used in the floating point format they use.
as a result, very large numbers end up being aproximated to the maximum number of digits used by the internal format.
it was probably not anticipated that a user would require arbitrary precision arithmetic.
18 digit integers are thus beyond the precision of coda arithmetic.
storing these numbers as text strings will preserve all the digits but they would still end up aproximated when used in arithmetical operations.
it would be good to get an official response from coda. you should raise this issue with coda support.
2 Likes