Validation method

Aspose.Cells Product Family
1

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);

validation.getAreaList();

thanks,
Zeljko.

2

@Zeljko,

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.