<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: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109240">109240</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>richard.leger@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134752" name="attach_134752" title="Sample file showing range created after two consecutive save following activation of AutoFilter">attachment 134752</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134752&action=edit" title="Sample file showing range created after two consecutive save following activation of AutoFilter">[details]</a></span>
Sample file showing range created after two consecutive save following
activation of AutoFilter
Hi,
Here is the scenario leading to bug...
01. Open new workbook and create a simple table with header columns
02. Rename the sheet: e.g 'Product Sheet'
03. Save file as in XLSX format
04. Close file
05. Re-open file
06. Above sheet, in cell name selection box (on the top left), select 'Manage
Names...' ==> no named ranges defined
07. Activate Data > AutoFilter
08. Above sheet, in cell name selection box (on the top left), select 'Manage
Names...' ==> no named ranges defined
09. Save file (keep XSLX format if prompted)
10. Close file
11. Re-open file
12. Above sheet, in cell name selection box (on the top left), select 'Manage
Names...' ==> a new named range now appear as defined in the list. 1 in total
listed.
09. Save file (keep XSLX format if prompted)
10. Close file
11. Re-open file
12. Above sheet, in cell name selection box (on the top left), select 'Manage
Names...' ==> another new named range (same as above but suffixed with _0) now
appear as defined. 2 in total listed.
13. If you keep repeating 09,10,11 new range keep being defined and added...
14. Close file
15. Open file in Excel 2016, it will chock on the file saying it is corrupted!
With inability to repair it... most likely because various named range refer to
the same range...
This seems to be a major compatibility issue...
May be related to <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - FILESAVE XLSX: Resaving file with autofilter on conditional formatting results in invalid XLSX"
href="show_bug.cgi?id=109144">bug 109144</a> (FILESAVE XLSX: Resaving file with autofilter on
conditional formatting results in invalid XLSX) ...</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>