[Libreoffice-bugs] [Bug 115513] Chart: Checkbox for zero values to be handled like missing values in plot options

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Feb 27 12:50:12 UTC 2018


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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #2 from Regina Henschel <rb.henschel at t-online.de> ---
If the data is 0, then it is correct to use this 0. The error in this case is,
that the chart is not based on the original data, but on a copy, which has a 0
instead of the blank cell.

To solve such problems, the user can use the original data or make a copy,
which indicates, that the original data does not exist, e.g.
 =IF(ISBLANK(Data.B9);NA();Data.B9)

I do not think, a new option in the chart is the correct way.

-- 
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/20180227/896f7c16/attachment.html>


More information about the Libreoffice-bugs mailing list