[Libreoffice-bugs] [Bug 109096] New: GEOMEAN gives Err:502 when an argument is zero

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: drozdik.svk at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170713/6c9e8488/attachment.html>