XML export bug in RadGridView

[Charles Covell]

Hi,

When using the "export to XML" feature of RadGridView, the resulting XML file is not proper XML when the GridView's data contains strings with the "<>" characters with something between them.  This appears to be because XML special characters:
< > & %
--are not escaped properly.

Would it be possible to get a fix/workaround for this?

Thanks!

Charley

[Veselin Vasilev]

Hello Charles Covell,

You can try escaping those characters in the ElementExporting event of RadGridView.

Kind regards,
Veselin Vasilev
the Telerik team

[Charles Covell]

Thanks for your response.  I was able to solve the issue by using your workaround.

In case anyone else reads this topic, here is the code for the ElementExporting callback I used:

private void myRadGridView_ElementExporting(object sender, GridViewElementExportingEventArgs e)
{
    if (e.Value != null && e.Value.GetType() == typeof(string))
    {
        e.Value = (e.Value as string).Replace("&", "&");
        e.Value = (e.Value as string).Replace("<", "<");
        e.Value = (e.Value as string).Replace(">", ">");
        e.Value = (e.Value as string).Replace("\"", """);
        e.Value = (e.Value as string).Replace("\'", "&apos;");
    }
}

Thanks,

Charley

[ErrolM]

Good afternoon Veselin,

Do Telerik have plans to implement this instead of all developers having to do it themselves?
I notice there is a ShouldEncodeValue field on the args (though I tried that before searching for this post).

Cheers,
Errol

[Pavel Pavlov]

Hi Errol Melvin,

I am shcheduling this for improvement for our next official release.

Regards,
Pavel Pavlov
the Telerik team

[azbola]

Did this ever make it into a release?

I seem to now see that headers are correctly encoded, but not data cells?

Thanks.

[Pavel Pavlov]

Hello Charles,

Please try the following :

public MainPage()
{
    InitializeComponent();

    gridView.Exporting += new EventHandler<GridViewExportEventArgs>(gridView_Exporting);

}

void gridView_Exporting(object sender, GridViewExportEventArgs e)
{
    e.ShouldEncodeValue = true;
}

Kind regards,
Pavel Pavlov
the Telerik team

[Pavel Pavlov]

Hello Charls ,

A quick update - for the latest versions please use the ElementExporting event instead .

* The Exporting event was recently  obsoleted.

Kind regards,
Pavel Pavlov
the Telerik team

[Mohd]

I am waiting for a reply from a long time


http://www.telerik.com/community/forums/silverlight/gridview/radgrid-export-to-excel-unable-to-maintain-decimal-format-for-number-less-than-4-digits.aspx