Created attachment 116086 [details]
Sample XLSX file with Selection List
All Selection Lists are removed on XLSX round trip.
Steps to reproduce:
1. Open SelectionList.xlsx or create a file in Excel with a Selection List in Calc
4. Open the new file
I can confirm with LO 4.4.3, win7
Were you the one that recently added the OOXML import logic to read selection lists?
What is a selection list? ;-p
(which hopefully answers your question ;-)
If you select an item from the list, Calc will export the list correctly. So the issue is only with empty selection lists being stripped out.
Data->Validity->Allow Empty Cells is checked. Also, saving as ODS preserves the selection list.
For .xlsx format it is not possible to create empty list for data validation (the error will be displayed during creation.
Also .xlsx format is not support such behaviour.
To resolve that, when empty list was specified, the error should be displayed
*** This bug has been marked as a duplicate of bug 41425 ***