Bug 31683 - Calc: Unable to display axis tick intervals with arbitrary label data.
Summary: Calc: Unable to display axis tick intervals with arbitrary label data.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: feature
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency treegraph
 
Reported: 2010-11-17 09:52 UTC by Kevin Hunter
Modified: 2017-09-14 22:59 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Example EIA data with charts, to show inability to pick a subset (39.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-11-17 09:52 UTC, Kevin Hunter
Details
Excel version of same data, this time with proper axis-tic intervals. (19.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2010-11-17 10:44 UTC, Kevin Hunter
Details
Screenshot of Excel version of same data, with proper axis-tic intervals. (122.20 KB, image/png)
2010-11-17 10:45 UTC, Kevin Hunter
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Hunter 2010-11-17 09:52:10 UTC
Created attachment 40341 [details]
Example EIA data with charts, to show inability to pick a subset

It appears that Calc does not support the idea of displaying a subset of axis labels for an arbitrary label set.

Say for year 1950 through 2000, I have nuclear and renewable energy data (that's three column headers "Year", "Nuke", "Renew", and three columns of data) and I want to view the stacked area plot for each year. Currently, I can:

 - select the data to be charted, but not the year column.  Then
   explicitly tell LO the axis range and interval.

 - Select all three columns, check the "first column as label" box,
   and let LO figure out it's own range based on the width of the
   graph and axis label font size.

The first method is a lot more work than it needs to be, and also does not handle tic labels that are not numerical.  The second is a "let it go" option rather than actually fixing the issue.

(Attached an example ODS file with some EIA data, but it's difficult to example this lack of feature without a dev trying it out.)
Comment 1 Kevin Hunter 2010-11-17 09:52:56 UTC
I should add that MS Excel 2007 appears to have a notion of axis label intervals that (almost) covers the use case.
Comment 2 Kohei Yoshida 2010-11-17 10:43:27 UTC
I'm taking this for the time being.
Comment 3 Kevin Hunter 2010-11-17 10:44:08 UTC
Created attachment 40342 [details]
Excel version of same data, this time with proper axis-tic intervals.

As requested by Koshida, here's an Excel 2007 version of the same data.
Comment 4 Kevin Hunter 2010-11-17 10:45:09 UTC
Created attachment 40343 [details]
Screenshot of Excel version of same data, with proper axis-tic intervals.

And, in case the xlsx file doesn't work, here's a screenshot of same.
Comment 5 Kevin Hunter 2010-11-17 10:48:01 UTC
One other tidbit, Excel doesn't seem to give an option to start the tic label interval at an arbitrary label.  Which is why, for instance, the screenshot starts at 1949, not 1950.  It would be nice to have the ability to start /labeling/ at any arbitrary tic, yet show all the data.
Comment 6 Roman Eisele 2012-05-03 09:48:46 UTC
This is a Calc/Chart issue, therefore changed the 'Component' field accordingly.

If I understand correctly, this is an enhancement request, therefore changing the 'Importance' field accordingly. Please change back if I missed something ...
Comment 7 QA Administrators 2014-10-23 17:32:21 UTC Comment hidden (obsolete)
Comment 8 Kevin Hunter 2014-10-24 13:13:09 UTC
(In reply to QA Administrators from comment #7)
> Your bug was confirmed at least 1 year ago and has not had any activity on
> it for over a year. Your bug is still set to NEW which means that it is open
> and confirmed. It would be nice to have the bug confirmed on a newer version
> than the version reported in the original report to know that the bug is
> still present -- sometimes a bug is inadvertently fixed over time and just
> never closed.

Sigh.  I recognize that LibO is largely a volunteer-based community, but this style of interaction doesn't give bug reporters much incentive to provide further bug reports.  That is, I believe the initial post and requested follow-up information -- all within the first hour after initial reporting in 2010 --*clearly* describe the problem / enhancement request: if bugs/enhancement requests like this can "time-out" without any thought-process or ownership from QA administrators or devs, then it is similarly not worth my time to write the corresponding prose in the first place.

Annoyance aside, yes, this bug report/feature request is still a valid issue to the best of my understanding of LibO 4.3 in Ubuntu 64-bit.

> Lastly, good bug reports help tremendously in making the process go
> smoother, please always provide reproducible steps (even if it seems easy)
> and attach any and all relevant material

This particular bug report is not "one of the weak ones" (the issue -- no method to display arbitrary axis labels -- is stated in the first sentence, and there are three supporting documents -- a LibO-created spreadsheet, an Excel-created version of same, and an image highlighting the proper behavior), exacerbating my earlier point about bug reporter frustration.  If the report were weaker, I might better understand, but it's not and thus my grievance with this LibO QA practice.