"precision as shown" causes incorrect arithmetic

[Ben Saylor]

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.

***
2011-02-10 - cannot reproduce in Libreoffice 3.3, Maverick -- leighman
***

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

[penalvch (penalvch)]

Ben Saylor, thank you for reporting this bug and helping make Ubuntu better. Does LibreOffice Calc work for you?

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

[Ben Saylor (brsaylor)]

Looks like the bug is fixed in LibreOffice Calc 3.3.2-1ubuntu5.

[penalvch (penalvch)]

Ben Saylor, the bug task for LibreOffice is being closed due to your last comment regarding this being fixed with an update to it. For future reference you can manage the status of your own bugs by clicking on the current status in the yellow line and then choosing a new status in the revealed drop down box. You can learn more about bug statuses at https://wiki.ubuntu.com/Bugs/Status. Thank you again for taking the time to report this bug and helping to make Ubuntu better. Please submit any future bugs you may find.

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.