Bug 85923 - Ultra thin bars and columns charts when using dates
Summary: Ultra thin bars and columns charts when using dates
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-05 16:35 UTC by Frank Berke
Modified: 2015-04-16 15:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Proof that charts get drawn incorrectly when x-axis is a date format (46.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-05 16:35 UTC, Frank Berke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Frank Berke 2014-11-05 16:35:27 UTC
Created attachment 108971 [details]
Proof that charts get drawn incorrectly when x-axis is a date format

Bars and columns charts get drawn in ultra thin lines, when the x-axis column is a 'date' format and contains a duplicate month.


Create a spreadsheet document, and on the first sheet, enter a data table where the first column contains date values, formatted like dd.mm.yy for example.

Insert a few dates, one for each month, e.g. 2.1.14, 3.2.14, 1.3.14, 2.4.14

Create a chart from the table and make the date column your x-axis (LO will most likely do so automatically)

Change one date on to force a duplicate month, e.g. change the second value to 30.1.14.

The chart will be re-drawn in ultra-thin lines.

If you change the value back, the chart will look correct again.

And despite different day numbers, the chart's label does not reflect them, but displays 01.mm.yyyy instead for every month.

The above does not happen with simple text in the first column.

A sample document that shows this bug is attached.
Comment 1 m_a_riosv 2014-11-05 22:37:12 UTC
Hi @Frank, thanks for reporting.

Your comment it's still reproducible with 4.2.7.

I think with the x-axis scaled as dates the issue comes because in this way you are subdividing the x-axis in days not in months, what implies the bar width it's for one day space.

I don't know with 3.3 (sorry it's a very old version), but in 4.2.7 changing the scale for x-axis from Automatic to Text solves the issue, because avoids the use of days in x-axis subdivision.

Resolves as notabug, please if you are not agree reopen it.