** Changed in: df-libreoffice
Status: Confirmed => Won't Fix
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1261048
Title:
[Upstream] Wrong results from rounding functions for large argument
Status in LibreOffice Productivity Suite:
Won't Fix
Status in “libreoffice” package in Ubuntu:
Won't Fix
Bug description:
1) lsb_release -rd
Description: Ubuntu Trusty Tahr (development branch)
Release: 14.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:4.1.3-0ubuntu3
Candidate: 1:4.1.3-0ubuntu3
Version table:
*** 1:4.1.3-0ubuntu3 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
100 /var/lib/dpkg/status
I am using Ubuntu 12.04.3 LTS and within that LibreOffice 3.5.7.2,
Build ID: 350m1(Build:2) but this is also reproducible in LO Trunk
4.3.0.0.alpha0+ on Windows Vista:
What is expected to happen at a terminal:
cd ~/Desktop && wget
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+attachment/3942054/+files/LibreOfficeRoundingIssues.ods
&& localc --nologo LibreOfficeRoundingIssues
Is that for cell D5 is it 0.
What happens instead is that it is 5. This would be an issue with Calc
numerical precision, as the actual outcome of 5 is also the same with
Excel.
WORKAROUND: Use gnumeric:
apt-cache policy gnumeric
gnumeric:
Installed: 1.12.9-1
Candidate: 1.12.9-1
Version table:
*** 1.12.9-1 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/universe amd64
Packages
100 /var/lib/dpkg/status
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386
(20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1261048/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp