After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 458158 - Formula changes on open
Formula changes on open
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export other
git master
Other All
: Normal blocker
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-07-19 01:52 UTC by Andreas J. Guelzow
Modified: 2007-07-19 13:52 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2007-07-19 01:52:20 UTC 
Create a new file with the formula
=tinv(0.2,1000000000000)
save the file as a gnumeric file
reopen the file
the formula has become
=tinv(0.2,-727379968)
Comment 1 Andreas J. Guelzow 2007-07-19 04:28:00 UTC 
Some more info:
The problem occurs when opening the file since the file does contain the right information:
        <gnm:Cell Row="18" Col="3">=tinv(0.2,1000000000000)</gnm:Cell>


I should also note that I didn't type in that big number like this but as:
=tinv(0.2,1E+12) but Gnumeric changed it to the value given above.
Comment 2 Jean Bréfort 2007-07-19 06:32:32 UTC 
I can't reproduce, but this formula gives #NUM for me.
Comment 3 Morten Welinder 2007-07-19 13:52:33 UTC 
Only occurs when int!=long.

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.