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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Validation

Thread ID:

Created:

Updated:

Platform:

Replies:

69512 Oct 31,2007 06:33 AM UTC Nov 2,2007 12:08 PM UTC WinForms 3
loading
Tags: GridControl
Thomas
Asked On October 31, 2007 06:33 AM UTC

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 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

Thomas
Replied On November 2, 2007 06:18 AM UTC

Does the Excel Import/Exporter set this properties automagically?

Sincerly Thomas Stocker

Jeba S [Syncfusion]
Replied On 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.



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.

Warning Icon 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.Close Icon

;