** Also affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Summary changed:
- [upstream] Sum error when using three cells and a large #.
+ [upstream] Calc precision error subtracting 3 integers
** Description changed:
Binary package hint: openoffice.org
- Cell A1=806515533049393
- Cell B1=1
- Cell C1=806515533049393
- Cell D1=A1-B1-C1=0
+ 1) lsb_release -rd
+ Description: Ubuntu 11.04
+ Release: 11.04
- If the contents of B1 and C1 are swapped, the correct answer of -1 is
- given.
+ 2) apt-cache policy libreoffice-calc
+ libreoffice-calc:
+ Installed: 1:3.3.2-1ubuntu5
+ Candidate: 1:3.3.2-1ubuntu5
+ Version table:
+ *** 1:3.3.2-1ubuntu5 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386
Packages
+ 100 /var/lib/dpkg/status
+ 1:3.3.2-1ubuntu4 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
- OpenOffice 2.4.1 on x86 Ubuntu 8.10 Intrepid Ibex. This error did not
- occur when performing the same numerical calculation in the bash shell:
- echo $((a-1-a)).
+ 3) What is expected to happen in LibreOffice Calc via the Terminal:
+
+ cd ~/Desktop && wget
+
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/340051/+attachment/486207/+files/openoffice.summation.bug.ods
+ && localc openoffice.summation.bug.ods
+
+ is that cell A1=806515533049393 cell B1=1 cell C1=806515533049393 and
+ cell D1=A1-B1-C1=-1.
+
+ 4) What happens instead is cell D1 is 0.
+
+ WORKAROUND: Use Gnumeric.
+
+ apt-cache policy gnumeric
+ gnumeric:
+ Installed: 1.10.13-1ubuntu1
+ Candidate: 1.10.13-1ubuntu1
+ Version table:
+ *** 1.10.13-1ubuntu1 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
+ 100 /var/lib/dpkg/status
+
+ WORKAROUND: If the contents of B1 and C1 are swapped, the correct answer
+ of -1 is given.
+
+ Original Reporter comments: OpenOffice 2.4.1 on x86 Ubuntu 8.10 Intrepid
+ Ibex. This error did not occur when performing the same numerical
+ calculation in the bash shell: echo $((a-1-a)).
ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 8.10
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:2.4.1-11ubuntu2.1
ProcEnviron:
-
PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer
- LANG=en_CA.UTF-8
- SHELL=/bin/bash
+
PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer
+ LANG=en_CA.UTF-8
+ SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.27-11-generic i686
** Tags added: lo33
** Changed in: libreoffice (Ubuntu)
Importance: Undecided => Medium
** Changed in: libreoffice (Ubuntu)
Status: New => Triaged
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/340051
Title:
[upstream] Calc precision error subtracting 3 integers
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
