We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Excel Validation

In Excel you can specify validation Settings for
Cells like lists ore ranges in which the values should be.
Is there support in the Essential Grid for this validation settings.
Or do I have to do them myself?

Sincerly Thomas Stocker


3 Replies

HA haneefm Syncfusion Team November 1, 2007 04:50 PM UTC

Hi Thomas,

Try setting the ValidateValue property in a gridstyle object. It holds validation rules for the cell value that are being checked before any user chages are commited to tha grid cell's style object.

//C#
this.grid.Model[1,1].ValidateValue = New GridCellValidateValueInfo(true, 0.01, 1000, "bad number")

'VB.NET
Me.grid.Model[1,1].ValidateValue = New GridCellValidateValueInfo(True, 0.01, 1000, "bad number")

Best regards,
Haneef


TH Thomas November 2, 2007 06:18 AM UTC

Does the Excel Import/Exporter set this properties automagically?

Sincerly Thomas Stocker


JS Jeba S Syncfusion Team November 2, 2007 12:08 PM UTC

Hi Thomas,

Thank you for your update.

Our current implementation of Excel convertor does not set this property automatically.

Kindly let us know if you need any further assistance.

Regards,
Jeba.



Loader.
Live Chat Icon For mobile
Up arrow icon