IDataValidation ListOfValues returns ArgumentOutOfRange exception

[Megan Clark]

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]

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