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. Image for the cookie policy date

IDataValidation ListOfValues returns ArgumentOutOfRange exception


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?

1 Reply

SR Sridhar Syncfusion Team 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.


Live Chat Icon For mobile
Up arrow icon