Return-Path: X-Original-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BDC39D11D for ; Fri, 26 Oct 2012 17:49:48 +0000 (UTC) Received: (qmail 94778 invoked by uid 500); 26 Oct 2012 17:49:48 -0000 Delivered-To: apmail-incubator-ooo-issues-archive@incubator.apache.org Received: (qmail 94684 invoked by uid 500); 26 Oct 2012 17:49:48 -0000 Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-issues@incubator.apache.org Delivered-To: mailing list ooo-issues@incubator.apache.org Received: (qmail 94675 invoked by uid 99); 26 Oct 2012 17:49:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2012 17:49:48 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,LOTS_OF_MONEY X-Spam-Check-By: apache.org Received: from [140.211.11.123] (HELO sif.zones.apache.org) (140.211.11.123) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2012 17:49:47 +0000 Received: by sif.zones.apache.org (Postfix, from userid 80) id 5546873E8; Fri, 26 Oct 2012 17:49:27 +0000 (UTC) From: bugzilla@apache.org To: ooo-issues@incubator.apache.org Subject: [Bug 121281] New: spreadsheet total in error Date: Fri, 26 Oct 2012 17:49:25 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: spreadsheet X-Bugzilla-Component: formatting X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: healthfood@telus.net X-Bugzilla-Status: UNCONFIRMED X-Bugzilla-Priority: P3 X-Bugzilla-Assigned-To: ooo-issues@incubator.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: priority bug_id assigned_to short_desc bug_severity cf_bug_type cf_fix_difficulty classification op_sys reporter rep_platform bug_status version component product Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://issues.apache.org/ooo/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/ooo/show_bug.cgi?id=121281 Priority: P3 Bug ID: 121281 Assignee: ooo-issues@incubator.apache.org Summary: spreadsheet total in error Severity: normal Issue Type: DEFECT Difficulty: --- Classification: Application OS: All Reporter: healthfood@telus.net Hardware: All Status: UNCONFIRMED Version: AOO 3.4.1 Component: formatting Product: spreadsheet I do not know if I am on the correct forum for reporting this or IF I have selected the correct version. I don't know if this is the correct place for asking for help but I will try. I am having a wee bit of trouble with my spreadsheet. All the formulas seem to be working but once in a while, and only SOMETIMES the total is out by 1 cent. I am sending you a document for your review. On line one cell (D1) I have the amount I am working with $3,246.33. Line 4 through 9 are all percentages of this number I have formulated it so Line 9 cell (D9) is not included in the total of lines 4-9 so my total of D4:D8 = $648.27 which is CORRECT My PROBLEM is when I use a formula to add D9:D11 my answer on cell D11 says $811.58 BUT if you just look at the numbers you will see it is out by one penny. If I add that on a calculator or my in my head it should be $811.59 not $811.58. HELP! -- You are receiving this mail because: You are the assignee for the bug.