<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 Named range as chart data source not saved"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143623">143623</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Named range as chart data source not saved
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>enhancement
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>75057
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=173970" name="attach_173970" title="Example file from Excel">attachment 173970</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173970&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
This is followup to <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Fileopen: named cell ranges from MSO are not imported in charts (because not supported in LO)"
href="show_bug.cgi?id=64086">bug 64086</a>
Attached file contains a chart with named ranges used to specify its data
ranges.
These are imported incorrectly and when saved to XLSX with Calc the named
ranges are not used as the charts data ranges.
Steps to reproduce:
1. Open attached document
2. Save as XLSX
3. Reopen the file in Excel
Actual results:
The chart has incorrect data ranges set.
As a result the X axis labels change from a, b, c, d to 1, 2, 3, 4.
Changing the data in A2:A6 or B2:B6 has no effect on the chart display.
Expected results:
The data ranges of the chart should refer to the named ranges.
Changing the data in A2:A6 or B2:B6 should have an effect on the chart display.
LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ac80ec817eb07c77a51bc0729985a473c734182e
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] OOXML Chart object issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=75057">Bug 75057</a>] [META] OOXML Chart object issues
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>