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.

Cell Validation

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 02:00 AM

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.

Regards,
Lokesh

Damon Eckert
Replied On January 27, 2010 01:46 PM

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.



CounterExample_3e8a86a6.zip

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

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

IF(Workbook.Names.Contains(Formula))
//Your COde Goes here
EndIF

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

please,let us know if this helps.

Regards,
Lokesh

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.

;