https://bugs.documentfoundation.org/show_bug.cgi?id=143699
Bug ID: 143699
Summary: Data -> Validity [Cell range] doesn't save "Sort
entries" in xlsx format
Product: LibreOffice
Version: 7.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
