Hi,
I am using the UltraWebGridExcelExporter control to export from a grid to Excel. I have noticed that line breaks in the original source text are not not appearing in the exported Excel worksheet e.g.:
Original Text
thisisatest
Excel Cell Text
this is a test
How can I preserve the control chars in the resulting Excel?
Regards
Myles
We've now resolved it. We needed to set the grid column cells to multiple lines e.g.
grdImportedExcel.Columns[index].CellMultiline = CellMultiline.Yes;
We didn't spot this as our grid is invisible on the page.