[Libreoffice-bugs] [Bug 143699] New: Data -> Validity [Cell range] doesn't save "Sort entries" in xlsx format

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: prempa at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210803/7d7051f0/attachment.htm>