All ranges are deleted after save, close, and reopen.
Hi @Rodrigo, thanks for reporting. Please can you inform what is your Operating System and LibreOffice version.
Created attachment 113289 [details] ods dummy file with range ods dummy file with range
Created attachment 113290 [details] xls dummy file with range xls dummy file with range
Created attachment 113291 [details] xlsx dummy file with range xlsx dummy file with range
Steps to reproduce 1) Open the attached dummy file sourceFile.ods. 2) Go to Data -> Select Range... You can see a defined range named "data" 3) Save the file as MS Office file (both xls and xlsx) 4) Go to Data -> Select Range... You can see a defined range named "data" 5) Close the file 6) Reopen the xls (or xlsx) file 7) Go to Data -> Select Range... The range is missing. Same behaviour if you try to open both xls and xlsx file (attached) created with MS Office (sourceFile.xls sourceFile.xlsx). Tested on Windows and GNU/Linux with: * Version: 3.6.7.2 * Build ID: e183d5b * Locale: it_IT * OS: Windows 7 Home Premium SP1 x86 * OS: Ubuntu 14.04.2 LTS x86_64 * Version: 4.2.8.2 * Build ID: 48d50dbfc06349262c9d50868e5c1f630a573ebd * Locale: it_IT * OS: Windows 7 Home Premium SP1 x86 * OS: Ubuntu 14.04.2 LTS x86_64 * Version: 4.3.6.1 * Build ID: 9629686a67dd1f357477c13325e45a66f3452bb9 * Locale: it_IT * OS: Ubuntu 14.04.2 LTS x86_64 * Version: 4.4.0.3 * Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7 * locale: it_IT * OS: Windows 7 Home Premium SP1 x86 * OS: Ubuntu 14.04.2 LTS x86_64 * Version: 4.5.0.0.alpha0+ * Build ID: 1845b6af3991ca5521eef48aafe1d0489e2ff8f6 * TinderBox: Win-x86@42, Branch:master, Time: 2015-02-02_09:30:48 * Locale: it_IT * OS: Windows 7 Home Premium SP1 x86 * Version: 4.5.0.0.alpha0+ * Build ID: 52d1de87e9a77fc7929309b0365bd786406ce022 * TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-02-04_01:50:43 * Locale: it_IT * OS: Ubuntu 14.04.2 LTS x86_64 xls and xlsx files created with Office 365 * Version: 15.0.4675.1003 * Locale: it_IT * OS: Windows 7 Home Premium SP1 x86
So please be careful. These are not named ranges (range names, named expressions, ... You are talking about database ranges which don't have an equivalent in OOXML, so there is no easy way to store these information. Even if we would be able to store these information as part of some libreoffice extension in OOXML MSO would not be able to use these information. This is just a concept that is only available in ODF and not in OOXML.
Actually database ranges since 5.1 are saved to OOXML (.xlsx files) <table> elements, see https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references