Issue 121281 - spreadsheet total in error
Summary: spreadsheet total in error
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 121425
  Show dependency tree
 
Reported: 2012-10-26 17:49 UTC by Lorna
Modified: 2017-05-20 09:54 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Lorna 2012-10-26 17:49:25 UTC 
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!
Comment 1 Rob Weir 2012-11-13 01:37:22 UTC 
Did you intend to attach a file?  I don't see anything here.

This does not sound like a bug.  But it does sound like a confusion between display values and calculation values in a spreadsheet, something best resolved on the support forums.
Comment 2 Rob Weir 2012-11-13 19:10:07 UTC 
Not a bug.
Comment 3 SVN Robot 2012-12-03 11:59:21 UTC 
"orw" committed SVN revision 1416474 into trunk:
#121281# - correction of former solution (revision 1409212) - consider negati...
Comment 4 Oliver-Rainer Wittmann 2012-12-03 12:10:02 UTC 
Sorry, former comment of SVN Robot is wrong due to a typo in the commit message - shame on me.
Comment 5 binguo 2012-12-06 11:24:32 UTC 
It would be better if one attached file in this bug for verification. thanks.