Posted 30 May 2018, 4:23 am ESTIs there any way to bind CellRange Column values to FarPoint.Web.Spread.ComboBoxCellType with more than 255 character limit while exporting it to Exel.
How can we add CellRange to FarPoint.Web.Spread.ComboBoxCellType Datasource
Posted by: dubey_ank88 on 30 May 2018, 4:23 am EST
Marked as Answer
Replied 30 May 2018, 3:41 pm ESTHello,
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.