iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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 ";}
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!
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname