Radgrid Export with currency style

[zorro]

Hi team,

I'm using radgrid to export to excel file. Everything is ok except one thing. I would like to format the value as currency style but when exporting done the style is Accounting

I catch the event

grid_ExcelExportCellFormatting(object source
                               , ExcelExportCellFormattingEventArgs e)

and I handled in this as below

e.Cell.Style["mso-number-format"] = "Currency";

Please help!
Kim.

[Princy]

Hello Zorro,

Try setting the currency format as shown below.
C#:

void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
  if (e.FormattedColumn.UniqueName == "UniqueName")
  {
    e.Cell.Style["mso-number-format"] = "Currency";
  }
}

Thanks,
Princy.

[zorro]

Hi Princy,

Thanks for your way. I followed exactly but it's still "Accounting" style instead "Currency".
Is there another way?

Thanks

[Princy]

Hello,

I cannot reproduce the issue at my end. Please make sure that you are using ExportCellFormatting for changing the format and not the ExcelExportCellFormatting event which is marked as obsolete as from RadControls for ASP.NET AJAX Q1 2011.

Thanks,
Princy.

[zorro]

Thanks for your reply. I solved this issue. Please prefer if you interest by these link

http://stackoverflow.com/questions/11029409/radgrid-export-with-currency-value

http://kimcuhoang.blogspot.com/2012/06/radgrid-export-to-excel-with-custom.html (this is my personal blog)