Zero as empty string - GridViewDecimalColumn

[Amige]

I have several GridViewDecimalColumn columns, and I am using this string format: {0:N3}, I want to show 3 decimals, but if the value is zero I would like to show the value as an empty string.

 

1.12 = 1.120

0.8 = 0.800

2.9 = 2.900

0.0 = " " ?

Is there a way to accomplish this?

Regards,

Alberto

[Dimitar]

Hello Alberto,

You can use the CellFormatting event to change the text of the cell:

private void RadGridView1_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e)
{
    if (e.Column is GridViewDecimalColumn && e.CellElement.Value != null)
    {
        var value =(decimal)e.CellElement.Value;
        if (value == 0)
        {
            e.CellElement.Text = "";
        }
    }
}

I hope this will be useful. 

Regards,
Dimitar
Progress Telerik

[Amige]

Hello Dimitar,

That is what I was looking for.

Thanks,

Alberto