Excel Validation

[Thomas]

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

[haneefm]

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

[Thomas]

Does the Excel Import/Exporter set this properties automagically?

Sincerly Thomas Stocker

[Jeba S]

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.