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.

IDataValidation ListOfValues returns ArgumentOutOfRange exception

Thread ID:

Created:

Updated:

Platform:

Replies:

108801 May 13,2013 03:56 PM May 15,2013 04:35 AM ASP.NET MVC (Classic) 1
loading
Tags: XlsIO
Megan Clark
Asked On May 13, 2013 03:56 PM

Hi,

I am attempting to update a column within an existing excel workbook with list validation values retrieved from a database (listArray variable in code below).  A snippit of the code is:
                                        //create column drop-down
IDataValidation validation = sheet.Columns[1].DataValidation;
validation.DataRange = sheet.Columns[1];
validation.ListOfValues = listArray;
validation.PromptBoxText = "List";
validation.IsPromptBoxVisible = true;
validation.ShowPromptBox = true;
An ArgumentOutOfRange exception is thrown on the vaalidation.ListOfValues line because the combined string length is greater than 256 characters.  How do I get past this exception?


Sridhar [Syncfusion]
Replied On May 15, 2013 04:35 AM

Hi Megan,

Thank you for using Syncfusion products.

We could see the above reported query is similar in the incident 108316. We request you to follow up with the incident 108316 for further more updates on this reported query.

Thanks,
Sridhar.S


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.

;