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 547039 - formatting cells as percentage incorrectly rounds some values
formatting cells as percentage incorrectly rounds some values
Status: RESOLVED DUPLICATE of bug 509965
Product: Gnumeric
Classification: Applications
Component: Analytics
1.8.x
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-08-09 06:42 UTC by Aanjhan
Modified: 2008-08-23 22:13 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Aanjhan 2008-08-09 06:42:39 UTC 
Please describe the problem:
Originally reported in Launchpad link https://bugs.edge.launchpad.net/ubuntu/+source/gnumeric/+bug/240392

Copied Description:
Enter the value 0.265 in a cell. Format the cell as a percentage with zero decimal places - it will display as 26%.
This erroneous rounding does not happen with 0.275, 0.285.

I've found a few other values where this happens, eg 0.625

Steps to reproduce:


Actual results:


Expected results:


Does this happen every time?
Yes

Other information:
Interestingly, a value such a 0.275 gets rounded off to 28% but not 0.265. May be we are missing something?
Comment 1 Jean Bréfort 2008-08-10 06:41:15 UTC 
I don't see what is wrong. Rounding to the nearest even figure in such cases is a widely used convention (but not the only one). 026500001 is rounded to 27%.
Comment 2 Morten Welinder 2008-08-23 22:13:30 UTC 
Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.

See comment 4 in bug 509965.


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