ONLYOFFICE 7.0: online forms, password protection in sheets, collaboration improvements and much more
ONLYOFFICE 7.0 released

Dependent Drop Down

Docs
,
#1

Hello :slight_smile:

when creating a Dependent Drop Down in a spreadsheet on my nextcloud via “Data Validation” and “INDIRECT” like in this tutorial
https://trumpexcel.com/dependent-drop-down-list-in-excel/

I get the message:

The source must be a delimited list or a reference to a single row or column.

If I upload a working Excel the dependent drop down menu stops working.

Did I just do something wrong or is there an error in the implementation of this function in OnlyOffice?

#2

Greetings!

Could you please select only the values of the range and not it’s name (“L” on the screenshot) when creating it in the Name Manager and check if the issue persists?

Screenshot_18
Screenshot_181300×648 32.6 KB

Best regards

#3

Hello,

I created a brand new sheet to try it out.

grafik
grafik946×559 26.3 KB

#4

And created a drop down list.

grafik
grafik675×573 22.3 KB

#5

And then a dependent drop down list.

grafik
grafik667×592 22.5 KB

The dependent drop down list is only offering choices from the first column. So unfortunately also not working.

Oh by the way I am using OnlyOffice Version 6.4.2 Is this maybe the issue?

#6

Could you please update your Document Server to the current 7.0 version, change the editor’s language to English, provide us with a video-example of you reproducing this issue step-by-step and with the file you work on in this video?

Best regards.