<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 - Named ranges without sheet reference are exported as corrupted XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113991">113991</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Named ranges without sheet reference are exported as corrupted XLSX
</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>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>filters and storage
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>baron@caesar.elte.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>104839, 109178
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=137914" name="attach_137914" title="Sample ODS">attachment 137914</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=137914&action=edit" title="Sample ODS">[details]</a></span>
Sample ODS
- Define a named range in an empty spreadsheet, and delete the sheet reference
from the range. Eg. $A$1:$A$3 instead of $Sheet1.$A$1:$A$3
- Save as XLSX.
- Open in Excel.
=> In Excel the file opens with repair, and the named range is removed.
Apparently in Excel the ranges have to include the sheet name.
Attaching an ODS sample, and the corrupted XLSX saved from it.
Note how because the range always refers to the current sheet, and the range
A1-A3 (test_range) contains different values on Sheet1 and Sheet2, the result
of SUM(test_range) is different as well.
Not sure what would be the preferre fix... possibly add as many different
ranges as there are sheets?
Observed using 6.0 daily build (2017-11-06_23:18:19,
a5af0fd9f27af42cf2e8571f659cdad6e606215b), 3.3.0 / Windows 7.</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_NEW "
title="NEW - [META] Cell names bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109178">Bug 109178</a>] [META] Cell names bugs and enhancements
</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>