formatting cells as percentage incorrectly rounds some values

Bug #240392 reported by gil
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
gnumeric (Ubuntu)
Fix Released
Medium
Unassigned

Bug Description

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)

Tags: amd64 hardy saucy
Revision history for this message
Aanjhan Ranganathan (aanjhan) wrote :

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

Changed in gnumeric:
status: New → Confirmed
Changed in gnumeric:
status: Unknown → New
Changed in gnumeric:
status: New → Invalid
Revision history for this message
Charlie Kravetz (cjkgeek) wrote :
Changed in gnumeric:
status: Invalid → Unknown
importance: Undecided → Medium
status: Confirmed → Triaged
Changed in gnumeric:
status: Unknown → New
Changed in gnumeric:
importance: Unknown → Medium
Revision history for this message
Dana Lee Ling (dleeling) wrote :

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)
tags: added: amd64 hardy saucy
penalvch (penalvch)
description: updated
penalvch (penalvch)
description: updated
Revision history for this message
penalvch (penalvch) wrote :

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

Changed in gnumeric (Ubuntu):
status: Triaged → Fix Released
Changed in gnumeric:
status: New → Expired
penalvch (penalvch)
no longer affects: gnumeric (Ubuntu)
affects: gnumeric → gnumeric (Ubuntu)
Changed in gnumeric (Ubuntu):
importance: Medium → Undecided
status: Expired → New
importance: Undecided → Medium
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.