[Libreoffice-bugs] [Bug 144746] New: Calc Chart Does not produce LINE ONLY when there ar null values

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Sep 27 07:44:03 UTC 2021


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

            Bug ID: 144746
           Summary: Calc Chart Does not produce LINE ONLY when there ar
                    null values
           Product: LibreOffice
           Version: 7.2.1.1 rc
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

When there are gaps or nulls in the data then the "lines only" chart type
selection doesn't produce a visible line. Therefore it is not possible to
"select" the data series and amend its characteristics to make it visible.
However, it is possible to double click the chart and then select the "Chart
Type" toolbar button and modify the type to "Points & Lines", at which point
the lines appear. Pointless to try to amend any meaningful characteristics as
reverting to "lines only" disappears the chart again.
Attached is a 3000-row file with two charts. (Just in case it's a feature of
the data volumes)
The first has continuous data in the column(K), the second has nulls
interspersed with the data in the column(L).
Double click the lower chart
select "Chart Type" from the resulting toolbar
Change the chart type to "Lines Only"
Observe that the line disappears
Change the chart type to "Points & Lines"
Observe that the display is now "Points Only"
The only way to get any lines back is to;
Right-click the Data Series
Select "Options"
Activate the radio button "Continue line"  from "Plot Options"
If the line has been disappeared by the change of chart type it will revert to
a line display if the toolbar "undo" is activated.
NOTE: A standard filter has been set to "show" column D <343 to bring the data
into visual range.
Workaround: select "Points & Lines" and ensure the points are no denser than
the lines.

Version: 7.2.1.2 (x64) / LibreOffice Community
XXXXXXXXX even though the  panel doesn't mention this release XXXXXXXXXX

Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
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/20210927/6698fe0a/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list