<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 pointing to data range in external file breaks"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137847">137847</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Named range pointing to data range in external file breaks
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.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>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>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>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, szucs.attila3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>104839, 137805
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=166830" name="attach_166830" title="Data source file with data table from Excel">attachment 166830</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=166830&action=edit" title="Data source file with data table from Excel">[details]</a></span>
Data source file with data table from Excel
Attached Excel made file contains a named range that points to an external file
and references an Excel Tables values by their columns name.
When this file is saved unchanged in Calc and reopened in Excel, it finds
invalid contents.
Steps to reproduce:
1. Open attached file, check Edit – Links to external files: link is there
2. Save as XLSX and open it in Excel.
Actual results:
External file reference not saved, Excel indicates broken named range on open.
Expected results:
External file reference saved.
LibreOffice details:
Version: 7.1.0.0.alpha1+ (x64)
Build ID: f27c4ec5c864395f4cdaec32d7e95ff24e4f43c8
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Note: this may be a consequence of <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN XLSX Defined name pointing to data table does not resolve source file name"
href="show_bug.cgi?id=137846">bug #137846</a> but filing just in case it's
not.</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] Saved XLSX files that MS Excel can't open"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=104839">Bug 104839</a>] [META] Saved XLSX files that MS Excel can't open
</li>
<li>
[<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [META] XLSX (OOXML) Data range / Format as Table issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137805">Bug 137805</a>] [META] XLSX (OOXML) Data range / Format as Table 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>