Validation.AreaList.Add throwing error for new aspose cells

[agandhi.deloitte]

Hi,

We are using Aspose Cells new version and we are getting issues with Validation properties.It’s throwing error which says ‘Property AreaList is obsolete: Use Validation.Areas property instead’.Mentioned below is the code with i have written.

Dim _sheet As Worksheet
Dim validations As ValidationCollection = _sheet.Validations
Dim validation As Validation = validations(validations.Add(cellArea))
validation.AreaList.Add(cellArea)

What is the new property to be used for creating Cell area for validation?

[Amjad_Sahi]

@agandhi.deloitte,

Thanks for your query and sample code segment.

Well, you do not need the following line of code any more now:
validation.AreaList.Add(cellArea)

as you already created data validation based on “cellArea”:
Dim validation As Validation = validations(validations.Add(cellArea))

All you need to do is create the CellArea to be specified when adding data validation.

Thank you.