Posted 30 May 2018, 4:23 am EST
Is there any way to bind CellRange Column values to FarPoint.Web.Spread.ComboBoxCellType with more than 255 character limit while exporting it to Exel.
Forums Home / Spread / Spread for ASP.NET (Web Forms)
Posted by: dubey_ank88 on 30 May 2018, 4:23 am EST
Posted 30 May 2018, 4:23 am EST
Is there any way to bind CellRange Column values to FarPoint.Web.Spread.ComboBoxCellType with more than 255 character limit while exporting it to Exel.
Posted 30 May 2018, 3:41 pm EST
Hello,
You can create a combobox with items source set to the Column values within Spread sheet. However once this is exported to Excel the Validation list will not show characters more than 255 in the list. It is because the data validation list in Excel will consider it as typed-in delimited values and hence put a limit of 256 characters.
Thanks,
Deepak Sharma