I have a similar problem. I cannot change the string since the column is bound to the database. I have no idea how to make the column wrap if there are no spaces in the string. I am using Infragistics 10.3 in ASP.Net 4.0.

I have a similar problem. I cannot change the string since the column is bound to the database. I have no idea how to make the column wrap if there are no spaces in the string. I am using Infragistics 10.3 in ASP.Net 4.0.

Dev,

The Excel Exporter will put the text of the WebGrid cell into the Excel cell.  As far as the exporter is concerned, "<BR>" has no special meaning, so it's stored in the Excel file as plain text.

One solution is to use the RowExporting event of the UltraWebGridExcelExporter object, and modify the cells in e.GridRow to translate "<BR>" to the System.Environment.NewLine constant.  In a typical scenario, since the page's response will be replaced by the Excel file you generate, it's safe to modify the cell values in this way, since they won't be persisted.

An alternative solution is to use the RowExported event of the UltraWebGridExcelExporter object instead.  This time, you'd look through the Excel cells that were created, and replace any instances of "<BR>" with System.Environment.NewLine.  This is a safer approach in all cases, since you're not modifying the grid's values directly at all, at the cost of being slightly less efficient for performance.

Vince,

I have similar problem. actually on next step. My ultragrid correctly show line break in text using <br> tag.

eg  "Client<br>Name" is shown in grid column as -
Client
Name

Problem arises when i export this grid to excel. Excel file shows this <BR> tag as it is-

Client<br>Name
 
Any ideas? I am using ultrawebgrid v8.2 in asp.Vb.net
 
Thanks in advance
Dev