SaveExcel Error

SaveExcel Error

Posted by: addio777 on 6 March 2018, 12:35 am EST

• 

  addio777

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 March 2018, 12:35 am EST

  Hi.
  
  FpSpread SaveExcel Error Question…

  FpSpread Sheet ComboBox Data List 25.
  
  16 ComboBox Data List after downloading Excel.

  I was using FpSpread.SaveExcel ().
  
  Quantity difference is poor reason.

  Thanks.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 7 March 2018, 7:39 am EST

  Hello,

  Please make sure you are using the ExcelSaveFlag as ‘FarPoint.Excel.ExcelSaveFlags.ComboAsDataValidation’ to export the ComboBox data as validation strings.

  Please refer to the attached sample application where it exports the ComboBox 1with 25 items to Excel with no issues. Let me know if the issue still exists.

  Thanks,
  
  Deepak SharmaExcelSaveComboValues.zip

• 

  addio777

  • Post Options:
  • Link
    Copy

  Posted 8 March 2018, 7:11 am EST

  Thanks.

  I am using Spread version 10. Version 10 does not have FarPoint.Excel.ExcelSaveFlags.ComboAsDataValidation.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 March 2018, 5:21 am EST

  Hello,

  This is correct, v10.0 does not have this feature. You would need to upgrade to v11.0 in order to get this feature.

  Thanks,
  
  Deepak Sharma