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 2018/06/04 19:56:28 UTC
[Issue 127788] New: average function gives incorrect result
https://bz.apache.org/ooo/show_bug.cgi?id=127788
Issue ID: 127788
Issue Type: DEFECT
Summary: average function gives incorrect result
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: occurs-60189@mypacks.net
Target Milestone: ---
When using the AVERAGE function to find the average of a row of numbers it
gives an incorrect result. For example when averaging the numbers -875.63,
-402.21, -2300.03, -943.86, +1832.96, the correct result is: -537.7544,
but the AVERAGE function says it is +478.66. Both the sign and the number are
wrong! This is just 1 example from many rows I have on the sheet. When using
the SUM function, I get the correct result. (SUM(-875.63,
-402.21,-2300.03,-943.86,+1832.96)/5)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127788] average function gives incorrect result
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127788
Dave Fisher <wa...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_OOO_ISSUE
--- Comment #2 from Dave Fisher <wa...@apache.org> ---
User error.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127788] average function gives incorrect result
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127788
Dave Fisher <wa...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |wave@apache.org
--- Comment #1 from Dave Fisher <wa...@apache.org> ---
Do you have =AVERAGE(A1;A5) when you should have =AVERAGE(A1:A5)?
If I put your numbers in a column I can replicate your result with the ";" and
the correct result with the ":"
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127788] average function gives incorrect result
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127788
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.