Why is there a missing data point

[Triggerhousinggroup]

Greetings:

I have this spreadsheet where the graph produces a missing data point.

Here’s a link to the spreadsheet, a screenshot of the weird result, and a screenshot of Help->About for LibreOffice.

The spreadsheet above is a stripped-down version of the one where I discovered the issue. Produced by creating a new spreadsheet, copy/pasting the data only from the original, and creating a new graph on the data. It’s all pretty straightforward.

LibreOffice details (same as what’s in the screenshot):

Version: 6.0.4.2
Build ID: 1:6.0.4~rc2-0ubuntu0.16.04.1

This should be obvious from the above, but:

bick-ubtu3 ~$ cat /etc/lsb-release  
DISTRIB_ID=Ubuntu 
DISTRIB_RELEASE=16.04 
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.4 LTS" 
bick-ubtu3 ~$

[erAck]

There’s nothing missing, the date in A7 is 2018-05-07 not 2017-05-07, hence the X-axis has a gap at that position and the value is inserted at the proper position of the date series (here appended and shown last).