<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE XLSX Multi-level category labels property not saved"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126193">126193</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Multi-level category labels property not saved
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>