Bug 134845 - Data Validation, not saving "Sort Entries Ascending". When reopening File, Filesave-Fileopen
Summary: Data Validation, not saving "Sort Entries Ascending". When reopening File, Fi...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.5.2 release
Hardware: x86 (IA32) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-15 21:30 UTC by G
Modified: 2021-08-27 10:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Data Validation Error (5.50 KB, application/vnd.ms-excel)
2020-07-15 21:32 UTC, G
Details

Note You need to log in before you can comment on or make changes to this bug.
Description G 2020-07-15 21:30:52 UTC
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.
Comment 1 G 2020-07-15 21:32:08 UTC
Created attachment 163084 [details]
Data Validation Error
Comment 2 m_a_riosv 2020-07-16 18:22:01 UTC
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?
Comment 3 G 2020-11-21 00:00:20 UTC
Seems like there is No option to save that selection in .xls
So no more to assume that is Not a Bug