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:
In column A, make a list with a few duplicates
Create a dropdown for the column A and flag Sort entries
Save as .xlsx and close the file
Reopen the file and check the dropdown
The dropdown shows all the duplicates values
The dropdown should be filed by unique values
User Profile Reset: No
If you save the file in .ods all works as expected
I can't to reproduce the error because the reproduction steps are not detailed enough. For example, how do I create a dropdown list?
(In reply to Nina_Shtygailo from comment #1)
> I can't to reproduce the error because the reproduction steps are not
> detailed enough. For example, how do I create a dropdown list?
To create the dropdown:
Go in an empty cell B2
Data -> Validity -> Criteria -> Cell range
Deselect Allow blank cells
Flag Sort entries ascending
no repro in
Version: 18.104.22.168 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (ru_RU); UI: en-US
Created attachment 174041 [details]
Reproducer document per instructions
Created attachment 174042 [details]
The reproducer document and its xlsx version opened in Excel
Looks like this is a Calc-only setting. My Excel 19 does not have an equivalent option in the dialog. So XLSX save loses the setting.
Version: 22.214.171.124.alpha0+ (x64) / LibreOffice Community
Build ID: 7c38362dbe1922c9825dffb463072030948d406b
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
(In reply to NISZ LibreOffice Team from comment #5)
> Looks like this is a Calc-only setting. My Excel 19 does not have an
> equivalent option in the dialog. So XLSX save loses the setting.
Yes, I see it now.
On the other hand, it seems to me that Excel always creates lists without duplicates.
Obviously that's my limit, but I don't understand the need to list all data in a range including duplicates.
This is why I don't understand the need for that flag.
Then you are asking for a different thing, not duplicates even not sorted.
Please open a new bug - enhancement for that.