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 631364 - Bad value computed on reference rounding
Bad value computed on reference rounding
Status: RESOLVED DUPLICATE of bug 509965
Product: Gnumeric
Classification: Applications
Component: General
1.10.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-10-04 23:59 UTC by Eric Shattow
Modified: 2010-10-05 01:03 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Buggy Gnumeric reference rounding document (4.77 KB, application/octet-stream)
2010-10-04 23:59 UTC, Eric Shattow 		Details

Description Eric Shattow 2010-10-04 23:59:46 UTC 
Created attachment 171728 [details]
Buggy Gnumeric reference rounding document

Gnumeric 1.10.10 on Maemo Linux (Nokia N900 phone).

All literal values entered are NN.NN for decimal hours on a time card.

Bad value computed: 232.30

G18=sum(G2:G17) # 83.97
I18=sum(I2:I17) # 49.86
F18=sum(F2:F17) # 62.08
H18=sum(H2:H17) # 44.42
F19=(G18+I18)-(F18+H18) # 27.33
H19=8.5 # 8.50
I19=round(F19*H19,2) # 232.30
I21=round(round(F19,2)*H19,2) # 232.31
Comment 1 Andreas J. Guelzow 2010-10-05 01:03:18 UTC 
Some of the numbers in your example have no exact base 2 representation. So working with approximations of those numbers will yield sum unexpected results.

*** This bug has been marked as a duplicate of bug 509965 ***