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 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.
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
From memory, I had an AppStyle defined in the application entry point and this was overriding any changes that I was trying to make in code. As a test, you could make sure that you are not using an AppStyle and then see if any of your styles set in code 'stick'.
I think I created a StyleSet within the AppStyle with the fonts etc that I wanted on the excel sheet.
Hope that helps, sorry I don't have my code anymore so can't check exactly what I did