Hi, I have a currency value column in a radgrid, and exporting to excel using this function for formatting the currency cells
protected void RadGrid_OnExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
if (e.FormattedColumn.DataType == typeof (long))
{
e.Cell.Style["mso-number-format"] = "Currency";
}
}
This is based on advice in another post in this forum. Works very well, but it doesn't format the footer item which is an aggregated sum value. How do I format the footer to be currency as well?
Thanks for reading
protected void RadGrid_OnExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
if (e.FormattedColumn.DataType == typeof (long))
{
e.Cell.Style["mso-number-format"] = "Currency";
}
}
This is based on advice in another post in this forum. Works very well, but it doesn't format the footer item which is an aggregated sum value. How do I format the footer to be currency as well?
Thanks for reading