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.

Data Validation - Allow Non-List Values

Thread ID:

Created:

Updated:

Platform:

Replies:

117925 Jan 9,2015 04:00 AM Jan 15,2015 12:04 AM Windows Forms 3
loading
Tags: XlsIO
Anthony Consolati
Asked On January 9, 2015 04:00 AM

Hi

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.

Thanks. 

Attachment: 20150109_1858_e8f197f3.zip

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

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.

Thanks,

Sudha Ramachandran


Anthony Consolati
Replied On January 14, 2015 12:49 AM

Thanks

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 12:04 AM

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.

Regards,

Dilli babu



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.

;