<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: ‘X axis’ labels and legend names disappear from chart with Excel formula syntax"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119040">119040</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX: ‘X axis’ labels and legend names disappear from chart with Excel formula syntax
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.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>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=143890" name="attach_143890" title="Example document saved with Calc A1 formula syntax">attachment 143890</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=143890&action=edit" title="Example document saved with Calc A1 formula syntax">[details]</a></span>
Example document saved with Calc A1 formula syntax
If we insert a chart into the *.xlsx spreadsheet and save as *.xlsx with Excel
A1 formula syntax in the Formula Option, the X axis labels and the legend names
disappear.
Steps to reproduce:
1. Open LibreOffice Calc and create a simple chart (e.g.: Column)
2. Set the Formula Option to Excel A1 syntax: Tools -> Options ->
LibreOffice Calc -> Formula -> Excel A1
3. Save the file as *.xlsx and reload.
Actual results:
The X Axis labels and legend names of the chart will disappear. But if we do
the same steps, except we modify the Formula Option to Calc A1, nothing will
disappear.
Expected results:
The X Axis labels and legend names of the chart should not disappear even if we
set the formula syntax to Excel A1.
LibreOffice details:
Version: 6.2.0.0.alpha0+
Build ID: bb1d5780226bb1b9156580972eea9aa849178742
CPU threads: 1; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2018-07-03_05:56:48
Locale: hu-HU (hu_HU); Calc: group threaded</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>