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

Free Support Forum - aspose.com

Validation method

Hi, I am having a problem with getAreaList() method in Validation class. It is deleted in the new version of the aspose.cells for java. What should i use instead? I can’t seem to find proper documentation for it, can you please help me with it?

ValidationCollection validations = worksheet.getValidations();
Validation validation = validations.get(1);




Thanks for your query.

Well, in newer versions, you may try to use Validation.getAreas() method to fetch an array of cell areas. Moreover to add a cell area, you may try to use Validation.addArea(). Similarly to remove an area from validation, you may try to use Validation.removeArea().

Hope, this helps a bit.