[Libreoffice-bugs] [Bug 142343] VIEWING Chart with calculated floating values displays broken data labels

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
If you widen the columns K, L and M you'll see that the actual values are what
is displayed in the chart (and columns B,C,D,G,H,I already contain such
intermediary values). The General format rounds values to the available column
width. The unexpected values are due to not all decimal numbers being
representable as binary floating-point numbers, as usual. Chart does not know
about the current column width or the resulting rounded display values.

Use ROUND(...;1) or some such on intermediary or final results, or use a 0.0
number format on the final results which then is also used by the chart.

However, this will be tackled by ongoing work regarding double to string
conversion. Anyway, there'll always be values that are not exactly
representable in all arbitrary precisions.

Not sure if we could do anything about passing the current display value to
chart instead of the actual cell value if the cell has a General format. Or if
we even should do so.

-- 
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/20210518/8c980a4e/attachment.htm>