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

    ebw,


    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

    Hello,


    It is version 4.0.2005.2005 and can be gotten from our website www.clubFarPoint.com 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