** Description changed: Binary package hint: gnumeric - 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. + 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%. - I've found a few other values where this happens, eg 0.625 + What happens instead is it displays 26%. - This happens with all fairly recent versions of gnumeric I've tried, - including gnumeric-gtk 1.8.2-1ubuntu1 and gnumeric 1.7.8-0ubuntu1.1 + This erroneous rounding does not happen with 0.275, 0.285. I've found a + few other values where this happens, eg 0.625. - (The correct behaviour is observed in both Openoffice.org Calc, and in - MS Excel.) + 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> + 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)
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/240392 Title: formatting cells as percentage incorrectly rounds some values To manage notifications about this bug go to: https://bugs.launchpad.net/gnumeric/+bug/240392/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
