Bug 109094 - Chart adds intermediate dates which are not in the data table
Summary: Chart adds intermediate dates which are not in the data table
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-13 11:16 UTC by Samuel Mehrbrodt (allotropia)
Modified: 2017-07-13 14:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot (55.98 KB, image/png)
2017-07-13 11:16 UTC, Samuel Mehrbrodt (allotropia)
Details
Example document (Impress) (15.98 KB, application/vnd.oasis.opendocument.presentation)
2017-07-13 11:17 UTC, Samuel Mehrbrodt (allotropia)
Details
Example document (Calc) (13.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-07-13 13:19 UTC, Samuel Mehrbrodt (allotropia)
Details
same chart with text axis (14.05 KB, application/vnd.oasis.opendocument.presentation)
2017-07-13 13:38 UTC, Markus Mohrhard
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Samuel Mehrbrodt (allotropia) 2017-07-13 11:16:02 UTC
Created attachment 134609 [details]
Screenshot

See attached file/screenshot.
The data table has only four dates, but the chart somehow fills the gap between the dates and inserts more entries.
Comment 1 Samuel Mehrbrodt (allotropia) 2017-07-13 11:17:39 UTC
Created attachment 134610 [details]
Example document (Impress)
Comment 2 Samuel Mehrbrodt (allotropia) 2017-07-13 11:59:02 UTC
This broke somewhere between 3.3.4 (good) and 3.4.0 (bad).
3.3.4 can't read date values in the data table, it displays empty strings. When entering date values it probably treats them as strings too, which might explain the difference.
Comment 3 Samuel Mehrbrodt (allotropia) 2017-07-13 12:25:36 UTC
Probably introduced by this changes: https://cgit.freedesktop.org/libreoffice/core/log/?id=f329f09bb7a24c357cf1608c4b00c978892dc0bb&qt=grep&q=i25706
Comment 4 Samuel Mehrbrodt (allotropia) 2017-07-13 13:19:27 UTC
The same can be seen in Calc, with a simple dataset.
When the cells are formatted as dates, the bug appears. When they are formatted as text, the bug doesn't appear.
Comment 5 Samuel Mehrbrodt (allotropia) 2017-07-13 13:19:48 UTC
Created attachment 134613 [details]
Example document (Calc)
Comment 6 Markus Mohrhard 2017-07-13 13:38:08 UTC
Created attachment 134614 [details]
same chart with text axis

Showing that this is a feature and not a bug.
Comment 7 Samuel Mehrbrodt (allotropia) 2017-07-13 14:05:49 UTC
(In reply to Markus Mohrhard from comment #6)
> Created attachment 134614 [details]
> same chart with text axis
> 
> Showing that this is a feature and not a bug.

Thx!

For reference: 
1. Select the chart
2. Select "X Axis" from the "Chart element" dropdown in the toolbar
3. Click the "Format selection" button
4. Set "Type" to "Text" instead "Automatic".