<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 -> Validity [Cell range] doesn't save "Sort entries" in xlsx format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143699">143699</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Data -> Validity [Cell range] doesn't save "Sort entries" in xlsx format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>prempa@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
If you flag Sort entries in cell range and save in xlsx the option is not
flagged when you open again the xlsx file.
If you make the same and save in ods it works perfectly.
Steps to Reproduce:
1.
In column A, make a list with a few duplicates
2.
Create a dropdown for the column A and flag Sort entries
3.
Save as .xlsx and close the file
4.
Reopen the file and check the dropdown
Actual Results:
The dropdown shows all the duplicates values
Expected Results:
The dropdown should be filed by unique values
Reproducible: Always
User Profile Reset: No
Additional Info:
If you save the file in .ods all works 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>