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

Free Support Forum - aspose.com

Obsolete warning for Aspose.Cells.ValidationCollection.Add()

Hi,

I was updating the library to version 8.4.0.0 and am now getting a compiler warning:
‘Aspose.Cells.ValidationCollection.Add()’ is obsolete: 'Use ValidationCollection.Add(CellArea) method instead.'

Target: having a drop down with a number of entries to select. Most Filtering lists are inside a cell (Formula1), but if the list gets too long, an extra worksheet is used to host the entries.
Until now I used the approach as described in the aspose doc:
http://www.aspose.com/docs/display/cellsnet/Data+Filtering+and+Validation
Programming Samples: List Data Validation

Could anybody please hand me a link to an updated documentation or give a simple sketch on how to use the new method.

Thanks in advance.

Andreas


Hi,

Thanks for your posting and using Aspose.Cells.

Please see the following code explaining the usage of new method. We will also update the documentation soon.

C#
CellArea ca = CellArea.CreateCellArea(“A1”, “D10”);

//Create and apply myValidation to range A1:D10
int idx = worksheet.Validations.Add(ca);
Validation myValidation = worksheet.Validations[idx];