[Libreoffice-bugs] [Bug 89994] Wrong result of calculation for statistical function Mean in Writer tables

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=89994

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

Writer's formulas are using the old Writer formula engine, totally unrelated to
Calc. And in it, every cell used in the MEAN is counted, with a cell not having
a value counted as zero.

(In reply to A (Andy) from comment #1)
> On the other hand CALC computes it correctly = 2.

Computes what? "MEAN"? There's no such function in Calc. Calc's AVERAGE is a
different function.

Changing the definition of MEAN to mean something different would break
documents where it's currently used, where its current behavior is wanted.

Of course, making it possible to use Calc formulas (something that is possible
with ODF standard, by specifying which namespace is used for the formulas
internally) would make lives much better - but that's a separate problem.

Closing NOTABUG.

-- 
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/20201114/d0e62895/attachment-0001.htm>