Saving to an Excel file

Posted by: ebw on 8 September 2017, 1:27 pm EST

  • Posted 8 September 2017, 1:27 pm EST

    Version:    4.0.2003.2005


    I open a simple Excel file in Spread. The Excel file has certain cells that have a yellow background (fill color) and some have a no fill color.

    After saving it to an Excel format and reopen it, the yellow background color is lost. Any thoughts?


    Code to save the .xls file:

      Dim xlwWarnings As FarPoint.Excel.ExcelWarningList

      Dim bResult As Boolean 

      xlwWarnings = New FarPoint.Excel.ExcelWarningList

      bResult = FpSS1.SaveExcel(“Testfile.xls”, xlwWarnings)


    Thanks, ebw

  • Replied 8 September 2017, 1:27 pm EST


    When writing Excel files we use the standard 40 color palatte. If this yellow color is not one of the default 40 colors, then it would be replaced by the closest color in the default 40 colors. In the latest maintenance release of Spread for Windows Forms, we have now added source to create a custom palatte when ecporting to Excel. You should see with the latest mainteance release that this is now working.

  • Replied 8 September 2017, 1:27 pm EST

    Thanks Scott. What is the version number of the latest maintenance release that's available?
  • Replied 8 September 2017, 1:27 pm EST


    It is version 4.0.2005.2005 and can be gotten from our website by clicking on the Updates link on the left of the page.

Need extra support?

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

Learn More

Forum Channels