Public bug reported:

Binary package hint: openoffice.org-calc

When the "Precision as shown" option is enabled in Calc, formulas
performing arithmetic using cell references produce incorrect results.

Steps to reproduce:

1.  Under Tools->Options->OpenOffice.org Calc->Calculate, check the "Precision 
as shown" option.
2. In cell A1, enter the number 3.
3. In cell A2, enter the number 2.
4. In cell A3, enter the formula =A1+A2.  Observe that the result is 0 instead 
of 5.

Subtraction, multiplication, and division also produce incorrect
results.

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-26.48-generic 2.6.32.24+drm33.11
Uname: Linux 2.6.32-26-generic x86_64
Architecture: amd64
Date: Fri Dec 17 22:29:43 2010
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.utf8
 SHELL=/bin/bash
SourcePackage: openoffice.org

** Affects: openoffice.org (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug lucid

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/691813

Title:
  "precision as shown" causes incorrect arithmetic

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to