<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Data Validation, not saving "Sort Entries Ascending". When reopening File, Filesave-Fileopen"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134845">134845</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Data Validation, not saving "Sort Entries Ascending". When reopening File, Filesave-Fileopen
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>guillermo_alv@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>