Winfried Donkers W.Donkers at dci-electronics.nl
Wed Jul 26 10:05:43 UTC 2017

Hi Eike,

I'm looking at bug 109096.
The problem here is that ODFF1.2 does not have constraints for the number values and neither specifies a complete result description.
See http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018690_715980110

Geometric mean is defined as n-root( a1 * a2 * ... * an). This applies for n positive values a#.
This is awkward to compute as overflow is lurking in case of large values a and a large number n.
An alternative computation is given in ODFF, but the case of any value a# being 0 is not mentioned (result is then 0).
Any a# with value is a geometrically valid situation, unlike negative values which do not have any geometric meaning AFAIK.

I would propose an amendment of ODFF1.2 for GEOMEAN:
Constraints: numbers >= 0
Semantics: addition of Returns zero when one or more numbers have value 0.

What's your opinion?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20170726/0825198d/attachment.html>

More information about the LibreOffice mailing list