HTMLTextbox in Excel Export

[Jeremy]

I use an HTMLTextbox in my report to add line breaks in a field with <br />. When exports to Excel, the line breaks disappear. 

I know there is something in the Design Considerations for Report Rendering that says formatting is removed from the Excel export. Is there something I can do to get the line breaks in the cell, or is this something that will be fixed in a future version?

[Peter]

Hello Jeremy,

If your main goal is to insert line breaks our suggestion is to use TextBox item and within the Expression editor to insert line breaks with Enter key.

Kind regards,
Peter
the Telerik team

[Jeremy]

The data where the line breaks are stored are in the database and pulled into the field. Is there some code that I can have in the database field to have the line breaks?

[Peter]

Hi Jeremy,

Our suggestion is to utilize the following user function to replace the <br/> tags with \r\n:

public static string CarriageReturn(string p)
{
    return p.Replace("<br>","\r\n");
}

Kind regards,
Peter
the Telerik team