You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/10/26 19:49:25 UTC
[Bug 121281] New: spreadsheet total in error
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.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
--- Comment #1 from Rob Weir <ro...@apache.org> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
binguo <bi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |binbjguo@gmail.com
--- Comment #5 from binguo <bi...@gmail.com> ---
It would be better if one attached file in this bug for verification. thanks.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |121425
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
--- Comment #3 from SVN Robot <sv...@dev.null.org> ---
"orw" committed SVN revision 1416474 into trunk:
#121281# - correction of former solution (revision 1409212) - consider
negati...
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |INVALID
--- Comment #2 from Rob Weir <ro...@apache.org> ---
Not a bug.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121281] spreadsheet total in error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121281
Oliver-Rainer Wittmann <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orw@apache.org
--- Comment #4 from Oliver-Rainer Wittmann <or...@apache.org> ---
Sorry, former comment of SVN Robot is wrong due to a typo in the commit message
- shame on me.
--
You are receiving this mail because:
You are the assignee for the bug.