I created a data range and created a validation field (drop down) with that range.
This all works in in the standard open format (.ods), but looses the data range when I save the spreadsheet in MS formats (xls, xlsx).
Created attachment 69782 [details]
Sample document that show the bug
Confirmed on LO 220.127.116.11 Windows Vista 32bit
1. Open the attached .ods. There is a range called "TheRange".
2. Save as .xls
3. Close and reopen the .xls
4. Go Data->Select Range
There should be a range called "TheRange"
This may be related to
Bug 42910 - [Calc] xls export corrupts some formulas with named ranges
This is still a problem, tested in Version: 18.104.22.168
Build ID: 125e3e788aa207ab80b6f39e74ef57af7e2129b6 MacOS.
Named ranges don't survive roundtrip ODS>XLS>ODS. Tested with very simple case.
*** This bug has been marked as a duplicate of bug 41425 ***