<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - 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#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - 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">bug 109240</a> from <a class="email" href="mailto:richard.leger@gmail.com" title="Richard Léger <richard.leger@gmail.com>"> Richard Léger</a> <pre> FYI it seems Excel also prefix such named range names with '_xlnm.' (without quotes)... while LO does not use that prefix when saving in .xlsx format. Dupicate named range names seems recreated(or loaded) when file is opened... clicking Save button does not recreate the range (at least not apearing in LO interface) until the file is closed/reopened. Hope that help.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>