Posted 8 September 2017, 1:27 pm EST
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)