Export removing leading zeros issue

[thdwlgP]

I am trying to export the grid data as all string so that none of the numbers that start with zeros would be truncated in excel. So to do that I thought I could do something like this

     void RadGridView_DataLoaded(object sender, System.EventArgs e)
        {
                for (int i = 0; i < ColumnHeaders.Count; i++)
                {

                    (uxGrid.Columns[i] as GridViewBoundColumnBase).DataType = typeof(string);
                }
            }
        }


but the format exported is still in
<td>01 2012</td><td>0008000.0000</td><td>04395.70</td></tr> without the ="" so it looks like ="0008000.0000"

any ideas?

[Nick]

Hello Jihae,

You can use the GridView.ElementExporting to modify the value that is being exported at the moment. 
You can see how this event can be used in our online example here. Or you can read about it in our documentation here.

Hope this helps! 

Kind regards,
Nik
the Telerik team

[thdwlgP]

Is there a way to do that with version 2009.2.828.1030?