[upstream] Calc precision error subtracting 3 integers
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Confirmed
|
Wishlist
|
|||
OpenOffice |
In Progress
|
Unknown
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
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://
100 /var/lib/
1:
500 http://
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https:/
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://
100 /var/lib/
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
NonfreeKernelMo
Package: openoffice.org-core 1:2.4.1-11ubuntu2.1
ProcEnviron:
PATH=/
LANG=en_CA.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.27-11-generic i686
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice: | |
status: | Confirmed → Unknown |
Changed in openoffice: | |
status: | Unknown → In Progress |
tags: | added: intrepid |
summary: |
- [upstream] Sum error when using three cells and a large #. + [upstream] Calc precision error subtracting 3 integers |
description: | updated |
tags: | added: lo33 |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Medium |
status: | New → Triaged |
Changed in df-libreoffice: | |
importance: | Unknown → High |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Changed in df-libreoffice: | |
importance: | High → Medium |
status: | Invalid → Confirmed |
Changed in df-libreoffice: | |
importance: | Medium → Wishlist |
Changed in openoffice.org (Ubuntu): | |
importance: | Medium → Low |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
Changed in df-libreoffice: | |
status: | Confirmed → New |
Changed in df-libreoffice: | |
status: | New → Confirmed |
This works on Excel but does not work on official OOo 3.0.1, so this bug needs to be sent upstream.
Thanks,
Chris