2009-03-09 17:13:17 |
Scott Krakiwsky |
bug |
|
|
added bug |
2009-03-09 17:13:17 |
Scott Krakiwsky |
bug |
|
|
added attachment 'openoffice.summation.bug.ods' (openoffice.summation.bug.ods) |
2009-03-09 17:13:17 |
Scott Krakiwsky |
bug |
|
|
added attachment 'Dependencies.txt' (Dependencies.txt) |
2009-03-19 21:30:59 |
Chris Cheney |
openoffice.org (Ubuntu): importance |
Undecided |
Medium |
|
2009-03-19 21:30:59 |
Chris Cheney |
openoffice.org (Ubuntu): status |
New |
Triaged |
|
2009-03-19 21:31:11 |
Chris Cheney |
bug |
|
|
assigned to openoffice |
2009-03-19 21:31:24 |
Chris Cheney |
summary |
Sum error when using three cells and a large #. |
[upstream] Sum error when using three cells and a large #. |
|
2009-03-21 03:00:37 |
Chris Cheney |
bug watch added |
|
http://qa.openoffice.org/issues/show_bug.cgi?id=100439 |
|
2009-03-21 03:00:37 |
Chris Cheney |
openoffice: importance |
Undecided |
Unknown |
|
2009-03-21 03:00:37 |
Chris Cheney |
openoffice: status |
New |
Unknown |
|
2009-03-21 03:10:08 |
Bug Watch Updater |
openoffice: status |
Unknown |
Confirmed |
|
2009-03-28 16:21:31 |
Chris Cheney |
openoffice: status |
Confirmed |
Unknown |
|
2009-03-28 16:30:34 |
Bug Watch Updater |
openoffice: status |
Unknown |
In Progress |
|
2010-05-13 21:38:48 |
Chris Cheney |
tags |
apport-bug |
apport-bug intrepid |
|
2011-06-04 14:44:08 |
penalvch |
bug task added |
|
libreoffice (Ubuntu) |
|
2011-06-04 14:46:28 |
penalvch |
summary |
[upstream] Sum error when using three cells and a large #. |
[upstream] Calc precision error subtracting 3 integers |
|
2011-06-04 14:51:16 |
penalvch |
description |
Binary package hint: openoffice.org
Cell A1=806515533049393
Cell B1=1
Cell C1=806515533049393
Cell D1=A1-B1-C1=0
If the contents of B1 and C1 are swapped, the correct answer of -1 is given.
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
SourcePackage: openoffice.org
Uname: Linux 2.6.27-11-generic i686 |
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://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
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
SourcePackage: openoffice.org
Uname: Linux 2.6.27-11-generic i686 |
|
2011-06-04 14:51:48 |
penalvch |
tags |
apport-bug intrepid |
apport-bug intrepid lo33 |
|
2011-06-04 14:52:00 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
2011-06-04 14:52:00 |
penalvch |
libreoffice (Ubuntu): status |
New |
Triaged |
|
2011-06-04 14:57:56 |
penalvch |
bug watch added |
|
http://bugs.freedesktop.org/show_bug.cgi?id=37923 |
|
2011-06-04 14:57:56 |
penalvch |
bug task added |
|
df-libreoffice |
|
2011-06-04 15:32:09 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2011-06-04 15:32:09 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
High |
|
2011-06-18 21:32:59 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Invalid |
|
2011-06-19 21:43:05 |
Bug Watch Updater |
df-libreoffice: status |
Invalid |
Confirmed |
|
2011-06-19 21:43:05 |
Bug Watch Updater |
df-libreoffice: importance |
High |
Medium |
|
2011-06-25 00:51:57 |
Bug Watch Updater |
df-libreoffice: importance |
Medium |
Wishlist |
|
2011-08-13 05:23:42 |
penalvch |
openoffice.org (Ubuntu): importance |
Medium |
Low |
|
2011-09-15 14:18:13 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
Triaged |
Won't Fix |
|
2014-11-04 04:20:25 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
New |
|
2014-11-18 05:25:51 |
Bug Watch Updater |
df-libreoffice: status |
New |
Confirmed |
|
2018-12-23 21:16:22 |
penalvch |
bug watch added |
|
https://bugs.documentfoundation.org/show_bug.cgi?id=37923 |
|
2018-12-23 21:16:22 |
penalvch |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|