Intersoft Community - WebGrid Enterprise - Export to excel issue - text in a column split into an extra row

Export to excel issue - text in a column split into an extra row

jeffqi — Wed, 24 Feb 2010 09:46:41 GMT

Add whitespace to column caption does address the issue. I also tried to set column width during Export event but that seems doesn't help. This sounds like a bug of WebGrid export function.

Thanks for your help Glenn!

Export to excel issue - text in a column split into an extra row

Glayaar — Tue, 23 Feb 2010 23:22:28 GMT

This issue occurs because the generated Excel report Price column width is not wide enough to support the data format. A workaround for this issue would be to add some whitespace to the Price column caption during Export server side event so the column width in the Excel will be wider. Here is the snippet:

protected void wgTest_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e)
{
    e.Table.Columns.GetNamedItem("Price").Caption = "Price     ";
}

Export to excel issue - text in a column split into an extra row

jeffqi — Tue, 23 Feb 2010 11:49:30 GMT

When using WebGrid's export to excel function, sometimes the text in a column is split into two parts, an extra row is created in excel, the second part of the split text is put in the extra row. I attached a screenshot of the exported excel file that having extra rows.

The DataFormatString applied to the affected column is "#,##0.0000"

Does anybody know how to fix this issue?

Thanks!

Jeff