Display of dropdown with multiple columns

Aspose.Cells Product Family
1

Hi,


I have a requirement where I need to show a dropdown with 2 columns (in excel). Like Code and Description. Upon selection of the value, the Code should be shown in the cell. Is this possible?

I am using Aspose.Cells.dll version 5.2.2.0.

Thanks in advance.
Gopal
2

Hi Gopal,

Thanks for your posting and considering Aspose.Cells.

Please provide us your expected sample excel file having your desired dropdown. You can create it manually using Microsoft Excel and attach it here for our reference. We will take a look in your sample dropdown and create the similar one using Aspose.Cells APIs and share a sample code with you.