Having trouble getting color scale conditional formatting from Excel file to show up in embedded spreadsheet in Windows Form

Question

I have a Windows Form that currently displays a spreadsheet that is editable. I have functionality to allow the user to browse for an Excel file to import to the spreadsheet in the Form view. It is important that an Excel file with a Color Scale Conditional Format be imported with the colors of the cells, as a result of the conditional format, to show up in the embedded spreadsheet.

I am currently using SpreadsheetGear's WorkbookView, but I have also discovered that SpreadsheetGear does not handle the conditional formatting with a color scale. Is there a way to either,

1. save the resulting cell colors from my excel object to apply later to the cells in my SpreadsheetGear object? Or,
2. Use a control in the Microsoft.Office.Interop.Excel namespace that DOES handle the color scaling conditional formatting found in existing excel files?

Answer 1

SpreadsheetGear is caught up with Excel's features from Excel 2007 and earlier. It will be a while before SpreadsheetGear implements the Conditional Formatting that includes Color Scaling because that wasn't added to Excel until after the 2007 addition.