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!