Hi all
I'm using the UltraGridExcelExporter and trying to set the font used in the excel workbook created to Verdana from the default Segoe UI, but with no luck yet.
I've tried setting the font on the grid itself and also in the initializerow event of the Exporter but neither seem to work.
Can anyone help me out here?
You can't set the default font of the workbook. You should be able to apply an appearance to any object in the export layout and have it export correctly, though. It depends, of course, on what grid objects you are looking at, though, and which ones already have font's applied to them.
Thanks for your very quick reply Mike. Your comments lead me to the fact that I am using an appstyle which overrides any appearance set in BeginExport. I just added a new StyleSet so it now works perfectly
I tried the approach found in the link below but it has no effect. Can you explain what you did to fix it?
http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Infragistics2.Excel.v8.2~Infragistics.Excel.Workbook~CreateNewWorksheetCellFormat.html
Hi asdfrong,
Which AppStyling? I did trun it off on the UltraGrid and it still did not work. The only thing that happened was my grid didn't look as nice.
Leaving AppStyling off my grid is not something I could do anyway, but thought I would give it a try for testing.
Hi Anomoly
I think I was setting an AppStyling at runtime in the application entry point which was overriding any changes I was making in code.
In my reply I did only mean remove any AppStyle for testing to make sure that nothing is overriding your styles that you are setting in code.
I'm sorry but I don't have my relevant code anymore and don't have infragistics installed on my current dev machine so can't be much more help.