We have been using Aspose.Cells to create a excel spreadsheet with ListBox controls. While that works pretty well, some of the functionalities we are looking for seems to be missing.
- In the listbox control created, we cannot make multiple items appear as selected as there is no method to do so (or are we missing something ?). Even if we set the SelectionType property as "Multi", we have only a SelectedIndex property available to set a single item as selected.
- While reading through an excel file containing listboxes (and one or more selected items in them) Aspose.Cells fails to report the selected items (SelectedIndex always returns -1)
- Also there is no way to determine the number of items in the list box. If we try to determine it via number of cells that forms the input for the list box, problem is that the InputRange property of list box always returns null.
Can you please help us out in resolving that? If we are missing something, can you pointing to some relevant doc links/threads where this was already discussed? I have attached a sample XLS file with this post.