Created attachment 125093 [details]
comparison of Excel 2013 and LibreOffice
CPU-Threads: 4; BS-Version: Windows 6.2; UI-Render: Standard;
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-01_13:08:56
Gebietsschema: de-DE (de_DE)
the chart at the sheet "Auswertug" is imported not correctly, see screenshot. the axis description is rotated by 45° and not all descriptions are displayed.
Created attachment 125094 [details]
Arch Linux 64-bit, KDE Plasma 5
Build ID: 1dbdc947fcc9d843764731e6dae7ce60082576e0
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default;
Locale: fi-FI (fi_FI.UTF-8)
Built on May 14th 2016
it's not a problem with import but with presentation
specific with presentation of multi line tick labels
the tick label in VDS90.ods, table "Auswertung", cell C36 is
"Organische Syndrome (Gedächtnis,
Excel displays this as "Organische Syndrome (Gedächtnis,..." in the chart.
While LO tries to squeeze both lines in the chart, fails and falls back to a 45° auto rotate mode. Then tries to display as many labels as possible in that mode. Then fails again (different bug I guess, details PS) and fits only 4 labels on the y-axis.
* open VDS90.ods
* goto table "Auswertung", cell C36
* unprotect sheet (tools - [x]protect sheet...)
* remove the second line from that cell value
--> Chart displays correctly
This bug exposes an other weird behaviour. There should fit more labels on y-axis in 45° rotation.
unprotect the sheet, select the y-axis, change text orientation to 1°
--> every second label is shown, including the one from C36
guess the overlapping check for tick labels is very basic.
The 45° auto rotate mode might be a good idea for x-axis tick labels but for y-axis tick labels it actually fits less labels than plain 0°.
So either improve the overlapping check for y-axis tick labels or disable the 45° auto rotate mode for y-axis.
Jochen Nitschke committed a patch related to this issue.
It has been pushed to "master":
try auto rotate tick labels only when useful tdf#99883
It will be available in 5.3.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #4)
> Jochen Nitschke committed a patch related to this issue.
> It has been pushed to "master":
> try auto rotate tick labels only when useful tdf#99883
Now every second tick label should be displayed.
Next step is to detect manual line breaks in tick labels
and shorten such labels at the line break if needed.
It might be a good idea to check for very long labels at the same time and shorten these too. see bug#89863
question is: what is too long?
Is this bug fixed?
If so, could you please close it as RESOLVED FIXED?
Created attachment 144818 [details]
How it looks in 6.2 master
Created attachment 144819 [details]
This is how it look in LO 6.2 on Windows.
This is how it look in LO 6.2 on Windows.
Dear Dennis Roczek,
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Created attachment 155629 [details]
The example file in current Calc master
Looks somewhat better in current master:
Version: 126.96.36.199.alpha1+ (x86)
Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
The problem is with the long "Organische Syndrome (Gedächtnis, Konzentration)" text.
Excel truncates this but LO does not.
To display all categories in LO one needs to enable the Overlap axis label property. Manually enabling it displays all labels, and Calc saves it to ODS correctly.
Excel has no such property, and because of the truncation behavior it does not need it. So it does not even save it in ODS.
The example ODS was last saved by Excel, this is why the Overlap property is missing and every second label is not displayed in Calc.
One can argue that this is not our bug. Manually reducing the length of that string makes all labels appear.
In the long run we should probably copy the label truncation behavior of Excel, there are other bugs about that.