We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cell as a Data Validation as a List (dropdown)

We are using an old version of Cells (aspose-cells-7.3.5.jar) and I want to use Cells to dynamically create an xlsx that has cells built with drop downs.
I have researched the Shape documentation and several other areas.
Can I ask whether our old version is able to do this ?



Thanks for your query.

Data validations (including drop downs or list type) were also supported in older versions (including aspose-cells-7.3.5.jar), see the document with example code for your reference:

Please note the example code is provided using newer/latest version of the product (Aspose.Cells
for Java v19.8). You may refer to the sample and write your code accordingly and it is also possible that you might need to update your code segment a bit.

PS. We also recommend you to kindly upgrade to and try our latest version of the product which has more enhancements and other fixes.

Thanks for your prompt response



You are welcome.