formatting cells as percentage incorrectly rounds some values

[gil]

Binary package hint: gnumeric

What is expected to happen is when one opens a blank workbook, enter in a cell 0.265, and format the cell as a percentage with zero decimal places, it displays 27%.

What happens instead is it displays 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.

This has happened since gnumeric 1.7.8-0ubuntu1.1 in Hardy.

WORKAROUND: Use LibreOffice Calc, or MS Excel via WINE.

ProblemType: Bug
ApportVersion: 2.12.5-0ubuntu2.1
Architecture: amd64
Date: Sun Oct 27 08:33:24 2013
DistroRelease: Ubuntu 13.10
InstallationDate: Installed on 2013-09-14 (42 days ago)
InstallationMedia: Xubuntu 13.10 "Saucy Salamander" - Alpha amd64 (20130902.1)
MarkForUpload: True
Package: gnumeric 1.12.6-1
PackageArchitecture: amd64
ProcEnviron:
 TERM=xterm
 SHELL=/bin/bash
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 LANGUAGE=en_US
 XDG_RUNTIME_DIR=<set>
ProcVersionSignature: Ubuntu 3.11.0-4.9-generic 3.11.0-rc7
SourcePackage: gnumeric
Tags: saucy
Uname: Linux 3.11.0-4-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)

[Aanjhan Ranganathan (aanjhan)]

Confirmed on Hardy gnumeric. 1.8.2
Very interesting. Thanks for reporting this issue. Forwarding upstream.

[Charlie Kravetz (cjkgeek)]

http://bugzilla.gnome.org/show_bug.cgi?id=547039 has been marked a duplicate of http://bugzilla.gnome.org/show_bug.cgi?id=509965

[Dana Lee Ling (dleeling)]

Interesting - this bug is still extant as of October 2013. I often use Gnumeric in lieu of Excel and LibreOffice in my statistics class because of Gnumeric's vaunted accuracy in statistical calculations. This bug is disturbing for a math instructor. At five years old, is this a bug that cannot be fixed because of some low level binary mathematics issue?

[penalvch (penalvch)]

gil, thank you for taking the time to report this bug and helping to make Ubuntu better. However, I am closing it because the bug has been fixed in the latest development version of Ubuntu - Vivid Vervet.

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please perform as much as possible of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure