[Solved] OnExcelExportCellFormatting

[Robert]

Inside the OnExcelExportCellFormatting instead of having to assign the "UniqueName":

if (e.FormattedColumn.UniqueName == "Freight")
{
  e.Cell.Style["mso-number-format"] = @"0";
}

Could we not Style all the datatype fields of date be automatically formated to the date format that you want?

[Daniel]

Hello Robert,

You could either set the mso-number-format to the desired columns only (as you did) or skip the conditional check and stylize all the columns with the same style. Unfortunately it's not possible to assign default styles in advance.

protected void radGrid1_ExcelExportCellFormatting(object source, ExcelExportCellFormattingEventArgs e)
{
    e.Cell.Style["mso-number-format"] = @"0";
}

Let me know if you need more information.

Kind regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.