FarPoint.Web.Spread.ComboBoxCellType data limitation

Question

  Preparing the excel sheet data from c# code and saving it does not populating all the data.

 I m using Farpoint.Web.Spread.ComboBoxCellType columns for dropdown list, the character length is limited to less than 255 chracters.

 

Usin the below code block :

 

FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType();

string[] arr = new string[50];
for (int r = 0; r < 50; r++)

{
      arr[r] = "ItemItemItemIten_ienenehn" + r;

} 

cb.Items = arr;

 

svFields.Columns[1].CellType = cb; 

 

Please help!