Subtraction error in spreadsheet

[Bob Scott]

Binary package hint: openoffice.org

Subtraction error at cell F19 in attached spreadsheet.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
Package: openoffice.org-core 1:3.0.1-9ubuntu3
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-12-generic i686

[Ben Crisford (bencrisford)]

I certainly cant argue with the file you attatched and it is certainly wrong.

But without the dollar sign, and the commar the sum works. Which seems a little odd to me.

Despite this however, it did give you an incorrect result and therefore I think I can confirm this, but if anyone disagrees feel free to change it.

Regards,
Ben

[Chris Cheney (ccheney)]

Verified in OOo 1:3.0.1-9ubuntu3, I need to check upstream version to determine where to send this bug.

[Chris Cheney (ccheney)]

Actually this isn't a bug as far as I can see. You aren't ever rounding the numbers to a certain precision you are just displaying them to a certain precision. If you add ROUND(BLAH,2) to various cells it causes the numbers to come out the way you want them to.

Chris

[Bob Scott (bobroxyscott)]

Chris, thanks. I must have messed with the ROUND function at one time,
but don't recall it.
Bob
-
Sent with a linux software computer. Certified no virus.

-----Original Message-----
From: Chris Cheney <email address hidden>
Reply-to: Bug 374244 <email address hidden>
To: <email address hidden>
Subject: [Bug 374244] Re: Subtraction error in spreadsheet
Date: Mon, 08 Jun 2009 15:48:12 -0000

Actually this isn't a bug as far as I can see. You aren't ever rounding
the numbers to a certain precision you are just displaying them to a
certain precision. If you add ROUND(BLAH,2) to various cells it causes
the numbers to come out the way you want them to.

Chris

** Changed in: openoffice.org (Ubuntu)
       Status: Triaged => Invalid