Currently Being ModeratedFeb 10, 2013 12:02 PM (in response to brianfromsooke)
Good find! That definitely appears to be a bug in the program. Entering the following number:
results in the program converting it to the following each time:
Grantend significant digits might be arguable, but it should definitely not change the value of the entered number. I'd send Apple feedback about this bug here: http://www.apple.com/feedback/numbers.html
Currently Being ModeratedFeb 10, 2013 9:02 PM (in response to Topher Kessler)
It's not a bug, it's a limitation. Integers that big are not supported. They are almost certainly stored as double precision floating point numbers.
I cannot reproduce the second issue. I can enter 45.2 with no problem.
Currently Being ModeratedFeb 10, 2013 9:40 PM (in response to Jeffrey Jones2)
Ah good point. I'm not a programmer, but in reading that value is at most 2^52 (with sign and exponent bits removed), resulting in a maximum number that has 16 places, so above this will be truncated. Hopefully a switch to 64-bit from its current 32-bit coding will fix the issue.
Nevertheless, given it handles them as input without any warning suggests it can still be considered a bug. Apple should update this to handle any supplied number, or impose a warning about such limits when large enough numbers are entered.
Currently Being ModeratedFeb 12, 2013 10:44 AM (in response to brianfromsooke)
Sorry but double precision computer jargon just doesn't do it.I should at least get the 16th digit with any Engineering language. If Apple wishes to allow a large entry for calculations on a spreadsheet basis, then Apple should be responsible for an accurate outcome. When you think about this, one cannot even store a 16 digit credit card number in Apple's Number's cell. By definition this is a bug without exaggeration. I am not sure if there is a clear understanding of this issue but it is the 16 digit and all following digits, that appear as 0s upon entry. Hopefully a patch can be generated to expand the numerical capabilities of Apple.
Did anyone else have a problem with the Apple calculator app that I have experienced. For those who didn't have a problem is there a setting or another program that is infuencing it or i have missed in making this work? It is version 10.8 (123)
Currently Being ModeratedFeb 12, 2013 12:31 PM (in response to brianfromsooke)
A credit card number isn't really a "number" in the sense that you would not multiply or divide it. It is a string of text whose characters all happen to be digits (or digits and spaces, the way credit card numbers are usually formatted). Format the cell as text, and enter as many digits as you want.
Numbers is not intended for ultra-high precision computation. It's a pretty esoteric mathematical application that would require more than 15 digits of input data. For what it's worth, Excel behaves exactly the same way.