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 551796 - ubuntu hardy, gnumeric 1.8.2 desimal problem causing strange results
ubuntu hardy, gnumeric 1.8.2 desimal problem causing strange results
Status: RESOLVED DUPLICATE of bug 509965
Product: Gnumeric
Classification: Applications
Component: General
1.8.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 671632 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2008-09-11 10:07 UTC by mikko
Modified: 2012-03-08 14:02 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description mikko 2008-09-11 10:07:57 UTC 
If I open a new document and write to a cell:

=1600-1603,54
result: -3,53999999999996

or
=1600,6-1603,54
result: -2,94000000000005

I did a couple of tests and there are some other numbers too.

If I write
=1600,00-1603,54
gnumeric takes "empty" desimals away and changes it to =1600-1603,54

But if I put
A1: 1600,00 (and change the cell type to number with 2 decimals)
A2: 1603,54
A3: =A1-A2

then the result is correct.
Comment 1 Morten Welinder 2008-09-11 12:44:27 UTC 
See bug 509965, notably comment 4.


*** This bug has been marked as a duplicate of 509965 ***
Comment 2 Morten Welinder 2012-03-08 14:02:20 UTC 
*** Bug 671632 has been marked as a duplicate of this bug. ***