<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 Selecting not adjacent cells as range of values leads to the disappearance of the chart"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114177">114177</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Selecting not adjacent cells as range of values leads to the disappearance of the chart
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.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>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=138134" name="attach_138134" title="Example file made with Excel 2013">attachment 138134</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138134&action=edit" title="Example file made with Excel 2013">[details]</a></span>
Example file made with Excel 2013
If we create a simple column chart in Microsoft Excel and we set not adjacent
cells as range of value, but the address range cells are next to each other the
chart will disappear after you save as the file as XLSX with LibreOffice Calc
and reload it.
Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells.
3. Add a new column chart to the spreadsheet.
4. Click on the empty chart with right click and choose “select datas”.
4. Select the value range, but select not adjacent cells.
(=(Munka1!$B$4;Munka1!$D$4))
5. Select the address range, but select adjacent cells. (=Munka1!$B$3:$E$3)
6. Save the file as XLSX and open with LibreOffice Calc.
7. Save as the file as XLSX and reload the file.
Actual results:
The chart disappears. You can see in LibreOffice Calc, that the selected value
ranges are lost.
Expected results:
The chart should not disappear, and the selected value ranges should be
preserved.</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>