[Libreoffice-bugs] [Bug 140672] New: Undefined values (empty cell) being treated as zero in table formulas

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140672
           Summary: Undefined values (empty cell) being treated as zero in
                    table formulas
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Ulrich.Windl at rz.uni-regensburg.de

Created attachment 170065
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170065&action=edit
Screenshot showing a table with undefined cells (using min, man, and mean)

As opposed to Calc, Writer treats missing cell data as zero.
That makes it hard to use functions like min, max or mean (the min will mostly
be zero for positive values, max will be zero for negative values, and the mean
will typically be too small.
See attached screen shot for a real-life example (measurement data when not all
measurements were made).

-- 
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/20210225/58db8ceb/attachment.htm>