Created attachment 175353 [details] Example file from Excel Attached example file was made in Excel and contains charts with multiple categories. The charts on the right have an automatic label rotation, which means the roman quarter labels and the years are horizontal in Excel. In Calc however if the data range is only partially covering the primary category with secondary data points, i.e. there is only one secondary data point for the last “2009” item in the data range, the labels are rotated. This does not happen if the data range fully covers the primary data point, even if there are no actual values filled in. Steps to reproduce: 1. Open attached document in Excel and Calc Actual results: The quarter labels are rotated 270 degrees on the “Axis rotation: empty” titled charts: a combined bar+line chart on top and a bar chart at the bottom. This does not happen for the right side charts that differ only in the size of the data range. Expected results: The quarter labels of the secondary data series are not rotated in any case. LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b60b6bfaafa1315e07108dba50f016975b619c59 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also in 7.0, 6.0 - 5.4 (although these rotated the years too), 5.3 and before did not show the secondary labels at all for these charts.
Created attachment 175354 [details] Screenshot of the original document side by side in Excel and Calc
Reproduced in Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: ea65215855462e5e48f7a3a78724c38b5fc0e4d1 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Dear NISZ LibreOffice Team, 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