Duplicate values in data validation list

Do you want to: Report a bug

In ONLYOFFICE Spreadsheet, when selecting “Data validation > List” and then selecting a range with duplicates (e.g. A, B, B, C), the list of values offered in the drop-down menu should be deduplicated (e.g. A, B, C) like they are in Microsoft Excel, but they are not.

Expected: unique liste of values

Observed: List of values with duplicates (potentially hundreds of duplicates, when trying to do dependant drop-downs)

OS version: Windows 10
App version: 8.3.2.19
Downloaded from: ONLYOFFICE website

Hello @Buck

We will take a closer look at your report. Please await my feedback.

Thank you for the patience. QA team confirmed that this behavior is a bug. Sorry for the inconvenience and thank you for the report. I will let you know once this issue is resolved.

1 Like