Posted 8 September 2017, 2:37 pm EST
The title says it all. I have 2 arrays (Items and ItemData) containing ID and Description.
The spread seems to add one blanc row to the combo, which is great so users can select an empty value.
But when selecting the empty value, an exception is thrown.
Here's my code:
Dim comboCellType1 As CellType.ComboBoxCellType = New CellType.ComboBoxCellType()
comboCellType1.AutoCompleteMode = AutoCompleteMode.SuggestAppend
comboCellType1.Editable = False
comboCellType1.EditorValue = CellType.EditorValue.ItemData
comboCellType1.Items = Items
comboCellType1.ItemData = ItemData
Spread1.ActiveSheet.Columns(2).CellType = comboCellType1