How can we add CellRange to FarPoint.Web.Spread.ComboBoxCellType Datasource

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.

  • Marked as Answer

    Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels