Newcomer

Drop Down in TableView not working.

Forum|Forum|2 years ago
September 22, 2023
3 replies
0 views

I have an excel template. I had a DataList on a cell coming from another sheet. I added the name ranges for the TableView as it gets data from SQl. It used to work but it has stopped working and the DropDown of the list doe not happen. It shows the arrow for the partuclar cell but when you click it does not show the list.

Thank You,

Indu

Excel Add In

J

JackLacava

OneStream Employee

This sounds like some issue between your excel code and your TableView. You might want to have Support look at it, we can't really help without extensive information (screenshots etc).

I

IBKAuthor

Newcomer

Thank You Jack. I have put in a ticket with OneStream. There is no code but a Data-> List from another sheet on that particular cell where I intend the drop down to be in. It also has a name value range as it is being returned by the Spreadsheet BR rule. It was working fine in OneStream but at some point, it stopped working.

M

MarkBird

Veteran

Table Views don't currently support drop down lists in excel. There are a couple of enhancement requests open to add this feature:

https://community.onestreamsoftware.com/t5/Planning-Analysis/Allow-for-multiple-drop-down-cell-columns-in-Table-View/idi-p/17323

https://community.onestreamsoftware.com/t5/Platform/Drop-down-list-for-Excel-table-views/idi-p/27437

Mark