[Libreoffice-bugs] [Bug 126193] New: FILESAVE XLSX Multi-level category labels property not saved

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126193

            Bug ID: 126193
           Summary: FILESAVE XLSX Multi-level category labels property not
                    saved
           Product: LibreOffice
           Version: 6.4.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

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 at 42, Branch:master, Time: 2019-06-27_04:11:18
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190702/6e6d3414/attachment.html>