Radgrid Exporting ExcelML with Carriage Return

[Mark]

Peeps,

Please save the hair I have left.  I want to export some data from a radgrid, but the radgrid has </br> in the data.  Im doing a find and replace in the RadGrid1_ExcelMLExportRowCreated function, replacing </br> with &#13;&#10;.  However the string is being encoded into HTML therefore it ends up looking like this in the xml &amp;#13;&amp;#10;.  How do I escape & so it gets injected as an ampersand, or is there anyway i can override an element that replaces all </br> to carriage return.  Surely someone has done this.

[Princy]

Hi Mark,

I guess you want to replace the </br> tag in Excel. Please take a look at the following forum to achieve this:
http://www.telerik.com/forums/radgrid-excel-export-lt-br-gt-to-new-line#VwafLsLn5kiZEQGK8ekjTw

Thanks,
Princy

[Daniel]

Hello Mark,

The line ending character in ExcelML is "&#10;". The easiest way to insert/replace it would be to use the GridExporting event as suggested in that forum post.

Regards,
Daniel
Telerik