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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
