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?
Winfried
Context
- ODFF1.2 GEOMEAN · Winfried Donkers
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.