Bug 54132 - Date formatted X-axis only supported for some chart types
Summary: Date formatted X-axis only supported for some chart types
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: 3.5.6.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-27 21:12 UTC by Nils Smeds
Modified: 2014-01-09 05:12 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Example of well and badly formatted axes label for dates (33.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-27 21:12 UTC, Nils Smeds
Details

Description Nils Smeds 2012-08-27 21:12:14 UTC
Created attachment 66191 [details]
Example of well and badly formatted axes label for dates

When creating a graph in LibreOffice sensible formatting of major/minor data labels is only supported for Bar graphs. That is, a simple bargraph can be created where the data labels are eg. the 1st of each month. For other graphs, such as line graphs or other XY graphs it is not possible to get labels on e.g. monthly or yearly basis (when leap years are included in the data set). Only workaround I have seen is to manually enter user labels on the graph.

It would be nice to have the option to configure any axis in any graph to be of special type such as date and be able to format the appearance of the axes accordingly.

In the attached example notice that double clicking the X-axes and looking at the Scale tab of the Format pop-up the chart has an option to use a Date type and select major/minor interals accordingly whereas the xy line graphs can not do that.

/Nils
Comment 1 Joel Madero 2012-10-19 19:34:33 UTC
Confirmed. Steps:

Download sheet attached
Select data
Insert - Chart
Chart Type - Column
Click Finish
Right click on X Axis Label (one of the dates)
Click "Format Axis..."
On Scale Tab, you'll see "Type" and you can select different types with options


Do the same with a line chart, you'll see that the options are not there. 

Enhancement request, medium

Medium- our charts should behave the same way. Not any higher than medium because I don't think a lot of people even use this feature (first time for me :) ).

ProposedEasyHack as the code should be there and can be modeled by looking at how column chart is done.
Comment 2 Markus Mohrhard 2013-01-24 15:56:23 UTC
Not an easy hack.

Chart2 code is one of the places that is horribly complicated and a endless source for confusion and regressions. Especially the date axis handling is quite non-intuitive.

I'd prefer if we won't mark chart2 bugs as ProposedEasyHacks because we have nobody who is confident enough to throw some code pointers into a bug report.
Comment 3 Owen Genat 2014-01-09 05:12:29 UTC
Summary amended for clarity and so it shows up more readily in searches.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.