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.
Unfortunately, activation email could not send to your email. Please try again.

Excel Validation

Thread ID:

Created:

Updated:

Platform:

Replies:

69512 Oct 31,2007 02:33 AM Nov 2,2007 08:08 AM Windows Forms 3
loading
Tags: GridControl
Thomas
Asked On October 31, 2007 02:33 AM

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 [Syncfusion]
Replied On November 1, 2007 12:50 PM

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
Replied On November 2, 2007 02:18 AM

Does the Excel Import/Exporter set this properties automagically?

Sincerly Thomas Stocker

Jeba S [Syncfusion]
Replied On November 2, 2007 08:08 AM

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.



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;