Description: I'm using LibreOffice, Version: 6.4.5.2 on a Mac, CPU threads: 4; OS: Mac OS X 10.15.5; UI render: GL; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US; Calc: threaded Attached File: "Data Validation Error.xls" Right Click on "C1", Select "Data Validation", Click on "Sort entries ascending", then Click "OK". Save the File. Close the File. Open the same file, and now the Selection List won't be sorted, and the "Sort entries ascending" won't be checked (option Not saved on file). Or Check Steps to reproduce Steps to Reproduce: 1. Open a new book with Calc. 2. Fill cells A1 to A4 with A, 2, B and 1 (sorted letters and Not sorted Numbers), respectively. 3. Select "C1", on the Menu select "Data", "Validity...", Select "Criteria", on Allow select "Cell Range", Click on"Sort entries ascending", on Source add "A1:A4" and then Click "OK" 4. Chek that the List is Sorted "1,2,A,B" 5. Save the File and Close the File 6. Open the same File 7. Go to C1 and Click on the List. Now the list is Not Sorted, and you have to select that again to be Sorted. Now if you close and open again, you will have to do it again and every time that you re-open the file Actual Results: Not Sorted Selection List Expected Results: Sorted Selection List Reproducible: Always User Profile Reset: No Additional Info: Seems to not be Saving the option selected, If this gets fixed, then when reopening the file, it will work as expected.
Created attachment 163084 [details] Data Validation Error
It works for me with ods file type but none with xls or xlsx. Do you know if the options it's available in excel?
Seems like there is No option to save that selection in .xls So no more to assume that is Not a Bug