Custom Data Validation

[Adrian Gingell]

Hi

Could you please point me at some examples of Custom Data Validation techniques? What I'd like to do is set the cell data validation 'Allow' to 'Custom' and then put a formula in the 'Source' field.

I've Googled this and come up with 'http://www.syncfusion.com/Products/Xlsio/windows/Articles/data_validation.aspx' but just get XML Parsing Error: no element found' when trying to view the page. Actually, I get this error quite often when trying to view Syncfusion pages, any idea why?

Thanks

Adrian

[Balamurugan R]

Hi Adrian,

Thank you for your interest in syncfusion products
Could you please use this link to get more examples about the
data validation.

http://www.syncfusion.com:91/products/xlsio/backoffice/Articles/data_validation.aspx

Please,let us know if you have any queries,

Regards,
Balamurugan

[Adrian Gingell]

Hi Balamurugan

So I set AllowType = ExcelDataType.User by what else do I need to do to set a custom formula? Please give me a clue.

I've tried various combinations of other IDataValidation properties but I never end up with 'Custom' showing in data validation when I later view the spreadsheet, it alway seems to be 'List'.

Regards

Adrian

[Geetha M]

Hi Adrian,

Thank you for the details.

You can set custom data validation using the code snippet given below.

validation.AllowType = ExcelDataType.Formula;
            validation.FirstFormula = "=IF(A2

Please refer to the sample placed in the link below and let us know if you have any questions.

http://help.syncfusion.com/samples/XlsIO.Windows/F92126/CustomDV.zip

Regards,
Geetha

[Adrian Gingell]

Thanks very much Geetha, much appreciated, it works a treat.

Adrian

[Geetha M]

Hi Adrian,

Glad to hear the solution worked for you.

Regards,
Geetha