Using the 8.1 version of the WinGrid and the Excel Exporter, I am able to export my grid results to Excel, just fine. A header row is included and, in the resulting Excel worksheet, I can see the 'value' of the header cells in the formula window of Excel. However, the actual header 'cells' appear to be blank.
In a separate application without appstyling, the same code works and I can see the values in the actual cells. Any ideas why the cells appear empty?
Okay, cool. I will try that. I also notice that the font name that results is something Segoui (i'd have to double-check) but the Excel dialog says that font is not installed on my system.
Thanks for the input, Mike.
jc
So the question here is.. why is the exported workbook picking the forecolor of the header, but not the BackColor. It's possible that the BackColor might be coming from some themed drawing, so Excel would not be able to do that. But this might also just be a bug. I recommend that you create a a small sample project demonstrating this and Submit an incident to Infragistics Developer Support.
In the mean time, you could probably work around the issue by handling the HeaderCellExported event and change the Format on the cells. You should be able to either change the ForeColor or BackColor of each header cell to make the text readable.
Hey, Mike!
Thanks for the response. The appearance of the grid in the application appears as white font on blue background using the 'Nautilus' style set. The resulting Excel worksheet, however, has the header row just white on white. As I click on each header cell, I can see the actual header text in the formula window. If I manually format the cell font in Excel, it displays just fine.
Hi Jerry,
The exporting should be WYSIWYG. So the colors used in the exported excel worksheet should be the same as those in the grid. So the only way the headers should be white-on-white in Excel is if they are also white-on-white on the screen. Is that the case?
Follow up.....okay, I feel a little silly but the font on the header row in the worksheet is 'white'; probably from the appstyling. Is there a way to override the font as I am exporting so that the entire worksheet uses a visible font?