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

IDataValidation ListOfValues returns ArgumentOutOfRange exception

Thread ID:





108802 May 13,2013 11:09 PM UTC May 15,2013 08:35 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Megan Clark
Asked On May 13, 2013 11:09 PM UTC


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 validation.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 08:35 AM UTC

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.



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