GNOME Bugzilla – Bug 306254
Numbers >= 2^31 and < 2^32 are mishandled as in number matcher
Last modified: 2005-06-02 13:15:06 UTC
Please describe the problem: When entering a large number into a cell formatted as "Number" with 0 decimal places, there seems to be some signed vs unsigned brokenness. e.g. 3000000000 appears as -1294967296 Steps to reproduce: 1. Create a new workbook 2. Change the format of the current cell to "Number" with 0 decimal places 3. Type 3000000000 and press enter 4. Adjust the width of the column to see the result Actual results: -1294967296 is entered into the current cell Expected results: 3000000000 is entered into the current cell Does this happen every time? Yes Other information: If you prefix the number with =, to make it an expression, the correct value is input. e.g. typing =3000000000 produces the expected result. The version of Gnumeric I am using is v1.5.1, from Debian sid (unstable). Since I didn't believe the problem to be Debian-specific, I thought I would report it straight to upstream, but if this is something which has long been fixed in your tree, I'll get onto Debian about it.
The bounds of this behaviour are as follows: Number typed in | Number displayed 2,147,483,648 (=POWER(2, 31)) | -2,147,483,648 4,294,967,296 (=POWER(2, 32)) | 4,294,967,296 2,147,483,647 (=POWER(2, 31) - 1) | 2,147,483,647 4,294,967,295 (=POWER(2, 32) - 1) | -1
Ugh. Confirmed. Note, that setting the format is necessary in order to observe this problem.
Fixed in cvs.