Grid export to excel new line issue

[Alex Vr]

Hello,

I have RadGrid with GridTemplateColumn that has text with <br> tags and some other html tags.
When I excport the grid to excel it splits every text line within the template row to cells.
How can I make all the text in the template cell exported as single cell?

Best Regards,
Alex Vr.

[Daniel]

Hello Alex,

Please have a look at this forum thread:
Export to Excel Issues

I hope this helps

Best regards,
Daniel
the Telerik team

[Alex Vr]

Hello Daniel,

Thanks for the quick reply.
It's exectly the problem I have (#2 in the post), however the solution didn't work for me.
I tried using:

protected void LeadsRadGrid_GridExporting(object source, GridExportingArgs e)
    {
        if (e.ExportType == ExportType.Excel)
        {
            string css = "<style type='text/css'> br { mso-data-placement: same-cell; } </style>";
            e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");
        }
    }

But it still splits the cells.
Maybe it's bacuse I'm using OpenOffice to view the files?

Best Regards,
Alex Vr.

[Daniel]

Hello Alex,

OpenOffice does not support the Microsoft Office HTML format. It parses the HTML code however the formatting tags/styles are probably ignored.

Regards,
Daniel
the Telerik team