I need to have a dropdown for the entire column in excel using Aspose.
I m using c# code and shapes.AddCombox to add a dropdown.
Aspose.Cells.Drawing.ComboBox comboBox = worksheet.Shapes.AddComboBox(1, 0, 2, 3, 22, 146);
comboBox.LinkedCell = “Sheet1!$C:$C”;
comboBox.InputRange = “Sheet1!N1:N109”;
comboBox.DropDownLines = 8;
Even if I have specified the entire range in LinkedCell, I m getting the combox in the first column alone. (Please refer Combox1 screenshot).
After selecting the value from the dropdown, the selectedindex value is appearing in the column header.Refer ComBox2 screenshot. I dont want the column header to change after selecting a value.
Please help herecomboBox1.JPG (27.1 KB)
comboBox2.JPG (63.3 KB)