Hi,
Can any one please let me know how to bind both text and value to a combo box.
for binding Aspose given comboBox.InputRange but it right now supports only text.
i used linkcell concept but it only giving 1 2 3 4 5 6 like numbers only but i need a combo box which can return our bind value when user selecting.
more over i am not able to set the dropdown value while rendering from applicaiton, i didn’t find any setter method for this, can you please help me out.
Hi,
I think you are talking about ComboBox form control that one can use/render in MS Excel. Aspose.Cells works the same way as Ms Excel does for ComboBox control. We cannot insert .NET control (e.g ComboBox/Dropdown etc.) or ActiveX control by Aspose.Cells. Well, I think you may use the following properties of combobox shape for your needs, e.g
- SelectedValue
- Text
- SelectedIndex etc.
To add more items to combo box control, you have to update the input range (insert your source data to the source input range) for the combo box. If you could do it directly or have some other ways in MS Excel, kindly let us know with a template file and give us complete details and steps involved. We will check it soon.
Thank you.