Bug 60971 - x-axis formatting in Calc
Summary: x-axis formatting in Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-02-16 20:22 UTC by marshall
Modified: 2013-11-18 23:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Libreoffice spreadsheet x-axis formatting - bad (147.07 KB, application/pdf)
2013-02-16 20:22 UTC, marshall

Note You need to log in before you can comment on or make changes to this bug.
Description marshall 2013-02-16 20:22:38 UTC
Created attachment 74953 [details]
Libreoffice spreadsheet x-axis formatting - bad

I have a spreadsheet that has numerous x-axis values which are dates. Previously, I had formatted the x-axis to show staggered values (since displaying them all just makes a black smear) and also to angle them at 45 degrees. This showed correctly in previous versions of Libreoffice and also Neooffice.
With this version 4 I now get the black smear of all values which is unreadable.
If I play around with Label and Positioning settings, I can get a staggered readable display, although only with somewhat random checking of checkboxes.

Meanwhile, Neooffice still correctly displays the original document and Libreoffice doesn't.

So something must've changed between version 3 and version 4.

I've attached 2 screenshots to show the difference. One is Libreoffice ver. 4 and the other is NeoOffice 3.3 which is the same as Libreoffice version 3 was.
Comment 1 Joel Madero 2013-03-21 19:35:29 UTC
Please attach the original file so that we can analyze it. marking as NEEDINFO once you attach the ODS, mark it as UNCONFIRMED and we'll take a look. Thanks!
Comment 2 QA Administrators 2013-09-24 01:44:01 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team
Comment 3 marshall 2013-09-25 20:02:13 UTC
Sorry for forgetting to reply sooner. The original issue seems to have gone away. I don't know how. I assume I tweaked enough settings but I really don't know. As I recall, there were only a few settings that affected this x-axis date display.
Also, I prefer not to send you the file since it is a large spreadsheet with data I'd rather not share.
For now, the issue has subsided. However, if it reappears I'll try to make a test sheet and repost that here.

Thank you.
Comment 4 Joel Madero 2013-09-25 23:35:42 UTC
Thanks for the feedback!