Recommended way to change font facename

[Administrator]

I need to apply a font to a range of cells. I''m starting out by just changing the font family (facename). I get a GridStyleInfoStoreTable, iterate through it and call store.SetValue(CellFontProperty, mygridfontinfo) on each item, and finish with calling gridmodel.SetCells(storetable).

Unfortunately this doesn''t seem to work as I get a red exception cell and null reference exceptions logged.

The above approach seems to work for back/fore color and cell value. Is there a correct way to change the facename while still using GridStyleInfoStore?

Thanks.

[Administrator]

Hi Jim, Instead of changing through SetValue, try using ModifyStyle method. Here is the code snippet.

                    if (this.gridControl1.Data[i, j] != null)
                    {
	          // this.gridControl1.Data[i, j].SetValue(GridStyleInfoStore.FontProperty, "Arial");
                        style.Font.Facename = "Arial";
                        style.Font.Bold = true;
                        this.gridControl1.Data[i, j].ModifyStyle(style.Store, StyleModifyType.ApplyNew);
                    } 

Refer to the sample for details Let us know if you need further assistance. Regards, Madhan.

Forum_39825.zip