Deafult value using List control

Aspose.Cells Product Family
1

Hi,

We are currently using a List control to provide the users with a DropDown functionality in the excel sheet. Can we have a default value shown to the user in the list?

This is the way in which we are creating the list. We have created a range in sheet2 with some values. Later we are adding those values through formula into sheet1 using the control type List.

Please provide with pointers,

Thanks in advance,
Nagarajan B P

2

Hi,

I am not very clear about your need. Could you elaborate more, what types of default value you want to show in the list box or in combo box? I think you may provide an example creating it in MS Excel manually to express your scenario and we will give you the necessary details how it can be accomplished using Aspose.Cells.

Thank you.

3

Hi,

Please set the input range of the list box.See following codes:

listBox.InputRange = "Sheet2!A1:A5";