[Libreoffice-bugs] [Bug 134845] New: Data Validation, not saving "Sort Entries Ascending". When reopening File, Filesave-Fileopen

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134845

            Bug ID: 134845
           Summary: Data Validation, not saving "Sort Entries Ascending".
                    When reopening File, Filesave-Fileopen
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: x86 (IA32)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: guillermo_alv at hotmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200715/7090919c/attachment.htm>