i set up NextCloud and OnlyOffice recently and I’ve started creating some spreadsheets for my project. I’m unable to work out how to control what items appear in a dropdown list which pulls its items from a range in another tab.
The file I’m working on is imported from an Excel spreadsheet someone else made and already contained a tab for items, one per line, which are chosen from a dropdown which appears on a particular cell in each line.
My problem is even after going through the help info, I can’t work out how the cells can be set to refer to a range of cells to use in the dropdown. I can’t edit what I’ve got, and I can’t work out how to set up a new dropdown with a new range.
Must be missing something, but what? Thanks.