Cell Formatting

[Hui Zhong]

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

[Administrator]

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.

[Hui Zhong]

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.