Posted 8 September 2017, 1:14 pm EST
We have a bound spread and I need to use a ComboBoxCellType on a certain column. What is the best way to accomplish the following:
1. Set spread column width = the widest combo box item (which may or may not be present in the underlying data) + width of the combo box drop down arrow
2. Set spread so combo box drop down arrow is only displayed when user clicks in cell
3. Clear combo box if user clicks outside of spread with a combo box drop down arrow visible (mimicing behavior if the user clicked on another cell and changed active cell)
Thanks in advance for any ideas and/or suggestions!