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

Cell Validation

Thread ID:





92613 Jan 25,2010 09:25 PM UTC Jan 28,2010 08:29 AM UTC ASP.NET Web Forms (Classic) 3
Tags: XlsIO
Damon Eckert
Asked On January 25, 2010 09:25 PM UTC

Is there a way to determine if the validation using a list has just values in it or uses a named range? I noticed that when I type in values for the validation it looks the same as a named range other than a named range only has 1 value. So my question is how do I determine if the user used a named range for validation or just have a list with 1 value (I know that sounds silly, but its possible)? The FirstFormula doesn't really tell me. ListValues is always nothing and ListInFormula is always false too?

Lokesh R [Syncfusion]
Replied On January 26, 2010 07:00 AM UTC

Hi Damon,

Thank you for using Syncfusion products.

Could you please send us a simplified sample, that explains your expectation more precisely and also the version of Essential Studio you have installed.


Damon Eckert
Replied On January 27, 2010 06:46 PM UTC

I have posted a direct trac issue and Manimala P is attending to it. But I will see if you answer quicker. :) Here is my attached sample with comments.


Lokesh R [Syncfusion]
Replied On January 28, 2010 08:29 AM UTC

Hi Damon,

Thanks for the update.

Yes,it is possible to check whether validation takes the values from NamedRange or ListOfvalues.we have a method called "Workbook.Names.Contains()"in that ,the Workbook.Names property gets or sets the NamedRange Values.I have added the sample codelines below.

Dim Formula as=DV.FirstFormula

//Your COde Goes here

The method returns true if the FirstFormula contains the Named range value else returns false

please,let us know if this helps.



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

or the page will be automatically redirected to 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