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 2013/03/07 02:34:49 UTC
[Bug 121860] New: Wrong calculation of sum
https://issues.apache.org/ooo/show_bug.cgi?id=121860
Bug ID: 121860
Issue Type: DEFECT
Summary: Wrong calculation of sum
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: admin@optimiert.es
CC: issues@openoffice.apache.org
Created attachment 80382
--> https://issues.apache.org/ooo/attachment.cgi?id=80382&action=edit
Red text shows bugs
A calculation using the function sum (SUMME) calculates wrong. Manual addition
of cells are correct. Other rows are correct too.
See spreadsheet in attachment. Buggy line is red.
First Value: 5047,48 (Manual addition = correct)
Second Value: 8494,44 (Sum function = wrong)
Thanks for solving. I would like to know if I made the mistake.
Dan
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121860] Wrong calculation of sum
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121860
hanya <ha...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |hanya.runo@gmail.com
--- Comment #1 from hanya <ha...@gmail.com> ---
Your range C11:AF11 contains some cells (O11, T11, Y11 and AD11) having values
under merged ranges.
They are added to the summation.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121860] Wrong calculation of sum
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121860
admin@optimiert.es changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|programming |code
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121860] Wrong calculation of sum
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121860
admin@optimiert.es changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |INVALID
--- Comment #2 from admin@optimiert.es ---
(In reply to comment #1)
> Your range C11:AF11 contains some cells (O11, T11, Y11 and AD11) having
> values under merged ranges.
> They are added to the summation.
Thanks for helping me out so quickly!
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.