https://bugs.documentfoundation.org/show_bug.cgi?id=109096
Bug ID: 109096
Summary: GEOMEAN gives Err:502 when an argument is zero
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 134611
--> https://bugs.documentfoundation.org/attachment.cgi?id=134611&action=edit
Minimal working example
Dear developers,
When computing the geometric mean of numbers containing zero, the answer should
be also a zero. Now the argument checking procedure is too strict and any zero
in the arguments causes an Err:502.
While there is some discussion on whether zero arguments should be allowed:
https://math.stackexchange.com/questions/91443/geometric-mean-of-a-dataset-containing-0s/91445
I think they definitely should. This would be in accordance with the Wikipedia
definition of geometric mean and also it would make things more consistent. One
can always detect the presence of a zero in arguments, because this is the only
situation in which GEOMEAN should produce a zero.
Thank you for your support!
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
