[Libreoffice-bugs] [Bug 109240] 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)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #3 from Richard Léger <richard.leger at gmail.com> ---

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170724/752d5dad/attachment.html>