Cell Formatting

I want to format the cellvalue to the format like #.000. I tried several events, like QueryCellInfo.., it did not work. Please see the attached example code, and see what''s the problem. Thanks.

Forum_407350.zip

Hi Hui, This happens, because the ( e.Style.CellValue = dt.Rows[e.RowIndex - 1][e.ColIndex – 1] ) value of the datatable that is assigned to the cellvalue becomes a string by default. This causes the format not to be assigned. You can avoid this, by converting the value to double. Here is the code snippet. private void gridControl1_QueryCellInfo(object sender, Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventArgs e) { if (e.RowIndex > 0 && e.ColIndex >= 4 ) { e.Style.CellValue = Convert.ToDouble(dt.Rows[e.RowIndex - 1][e.ColIndex - 1]); e.Style.Format = "##.000"; } } Let us know if this helps. Best regards, Madhan.

Thanks. It worked. >Hi Hui, > > This happens, because the ( e.Style.CellValue = dt.Rows[e.RowIndex - 1][e.ColIndex – 1] ) value of the datatable that is assigned to the cellvalue becomes a string by default. This causes the format not to be assigned. You can avoid this, by converting the value to double. Here is the code snippet. > > private void gridControl1_QueryCellInfo(object sender, Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventArgs e) >{ > if (e.RowIndex > 0 && e.ColIndex >= 4 ) > { > e.Style.CellValue = Convert.ToDouble(dt.Rows[e.RowIndex - 1][e.ColIndex - 1]); > e.Style.Format = "##.000"; > } >} > >Let us know if this helps. > >Best regards, >Madhan.