Created attachment 125093 [details] comparison of Excel 2013 and LibreOffice Version: 5.2.0.0.alpha1+ Build-ID: d8f73e1da3f799b004dec3875f433aa44685fc23 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] VDS90
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha1+ 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, Konzentration)" 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. proof: * 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 PS: 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=99226f343e4ad9ebcbb4e31c17d3fb706153e18b 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: http://wiki.documentfoundation.org/Testing_Daily_Builds 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": > > http://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=99226f343e4ad9ebcbb4e31c17d3fb706153e18b > > 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?
Hello Jochen, 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! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 155629 [details] The example file in current Calc master Looks somewhat better in current master: Version: 6.4.0.0.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 Calc: CL 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.
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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
(In reply to NISZ LibreOffice Team from comment #10) > Created attachment 155629 [details] > The example file in current Calc master > </snip> nothing changed with Version: 7.2.2.2 (x64) / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
Same in recent master build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e9a0c97de95688b2f86bbb4dd8c823af5442401c CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded