Free Support Forum - aspose.com

Adding validation to cells

Hi,

How to add input message validation to a perticular cell in excel sheet? I can see methods to add validations to cell area but not to individual cells.

Regards, Vinay

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Well, you may specify the cell area to one cell to specify the validation on that cell. Please see the following documentation link for sample code and details regarding cell validation.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/data-filtering-and-validation.html

We will also look into the feasibility of the feature (to add validation to a single cell) and get back to you soon. The feature request has been added in our internal issue tracking system with issue id: CELLSNET-16585.

Thank You & Best Regards,