I’m trying to build dependent drop down lists. You can find a how to (in Excel) here.
While creating these lists plus giving them names is not a problem, creating the validation is. Here is the code. (Feel free to format it. Somehow I was not capable to do so.)
ListName is the holding the name of the list object, which I’ve create before. When I’m opening the Excel document and expand the dropdown list, the name of the list is shown but not the values of the list object.
So what am I doing wrong? Am I using the wrong way to apply the valid value list?
Please send us a complete compilable/runnable project along with the output generated using Aspose.Cells. Also send us an Excel file which is generated using MS Excel and contains validations as you want. It will help us to compare the program output with the desired output and provide our feedback.
Thank you for providing the sample Excel file. We have understood the problem but we need your sample code too, from which you sent us excerpt in the first post. It will help us to review the code and provide our feedback. Please send us your complete simplified program which is runnable and can be executed here without any error for our analysis.
You may have a look at the code in the following link for your reference: