Description: Excel can use multi level axis categories and it indicates this with a separate “Multi-level category labels” property on the UI. While Calc can understand the presence of multiple level categories, this property is not exported to XLSX format, causing display differences in Excel. Steps to Reproduce: 1. Create a simple chart in Excel with two columns as category labels. For simplicity use the Recommended Charts feature for this. 2. Save the file as XLSX, open it in Calc 3. Save the file again and open it in Excel Actual Results: Under Format Axis -> Axis Settings open the Labels category the “Multi-level category labels” box is not checked and the labels appear concatenated. Interestingly: checking the box corrects the behavior. Expected Results: “Multi-level category labels” box state is retained. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.4.0.0.alpha0+ (x86) Build ID: d35171456bc230efdaa9426da1398b2db7fa0df8 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-06-27_04:11:18 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL
Created attachment 152505 [details] Example file from Excel
Created attachment 152506 [details] The original file saved by Calc
Created attachment 152507 [details] Screenshot of the original document side by side in Excel and Calc.
Hi NISZ LibreOffice Team, I reproduce with LO 6.4.0.0.alpha0+ (x86) Build ID: 719f4a93e46a6b397356dbb605d2867639ca3942 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; Locale: fr-FR (fr_FR); UI-Language: en-US Calc: CL and older versions. Have a nice day, Jacques
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/8906275d40a1828db684e7d9c9bc4934a937bc6c%5E%21 tdf#126193 Chart OOXML: Export Multi-level category labels It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.