Hi
There seems to be an issue when trying to set FontColor to via RGB.
If i am setting the version to xvExcel97 and setting the FontColor to RGB(255, 102, 0) it sets it to Orange as expected.
If i set the version to xvExcel2007 and then set the FontColor to RGB(255, 102, 0) it shows as a shade of blue. By examining the colour detail in the opened spreadsheet
it seems as if it is swapping the order of the RGB values around as it shows Red 0, Green 102 and Blue 255.
If i set the FontColor to the hex value it then sets it correctly for xvExcel2007 (orange) but incorrectly for xvExcel97 (blue).
We have just purchased the downloaded the latest version this morning(upgrading from version 4) as we need to give our users the choice between an XLS or an XLSX file.
Regards
David