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

Data Validation - Allow Non-List Values

Thread ID:





117925 Jan 9,2015 09:00 AM UTC Jan 15,2015 05:04 AM UTC WinForms 3
Tags: XlsIO
Anthony Consolati
Asked On January 9, 2015 09:00 AM UTC


In Excel, when setting data validation on a cell so it comes from a drop down list, there is an 'Error Alert' tab which allows you to untick 'Show error alert after invalid data is entered'. How can I set this tickbox to false in IDataValidation ? 
I have tried setting 
.ShowErrorBox & .ShowPromptBox to false, but still get a message box in Excel.


Attachment: 20150109_1858_e8f197f3.zip

Sudha Ramachandran [Syncfusion]
Replied On January 12, 2015 11:04 AM UTC

Hi Shamsul,

Thank you for using Syncfusion products.

We have analyzed your query and are unable to reproduce the issue. We have shared the sample that we tried for your reference. Kindly try the sample at your end and get back to us if the issue is reproducing. If not, please modify the sample to reproduce the issue and get back to us. This will help us to investigate further and provide you a prompt solution. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/117925/XlsIOSample-1262624178.zip

Please let us know if you have any queries.


Sudha Ramachandran

Anthony Consolati
Replied On January 14, 2015 05:49 AM UTC


I am setting the .DataSource property, rather than setting a specific list of values. I have discovered that you need to specify the .DataSource property before setting .ShowErrorBox otherwise it will not work. 

Dilli Babu Nandha Gopal [Syncfusion]
Replied On January 15, 2015 05:04 AM UTC

Hi Shamsul,

Thank you for updating us.

The given information about DataSource usage is not sufficient for us to reproduce the issue. Please provide us the code snippet or the sample in which you are able to reproduce the issue. This will help us to give you a prompt solution.


Dilli babu


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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