Hi,
I am using radgrid excel export using html format. In radgrid ExportCellFormatting event we are formatting the date column as below
If e.FormattedColumn.UniqueName = "t_UploadedOn" Then
e.Cell.Style("mso-number-format") = "dd\-mm\-yyyy\ HH\:mm\:ss\"
End If
The above works fine if date is something like 29-01-2015, but if date is like 1st of Feb 2015 then it will show as 02-01-2015. Please see the attached screen grab of recent export.
Any help would be greatly appreciated.
I am using radgrid excel export using html format. In radgrid ExportCellFormatting event we are formatting the date column as below
If e.FormattedColumn.UniqueName = "t_UploadedOn" Then
e.Cell.Style("mso-number-format") = "dd\-mm\-yyyy\ HH\:mm\:ss\"
End If
The above works fine if date is something like 29-01-2015, but if date is like 1st of Feb 2015 then it will show as 02-01-2015. Please see the attached screen grab of recent export.
Any help would be greatly appreciated.
1 Answer, 1 is accepted
0
Accepted
Hello,
Microsoft Excel parses the value automatically. I'm afraid that we do not have control over the value parsing. A possible solution would be to convert the values manually before exporting.
Regards,
Daniel
Telerik
Microsoft Excel parses the value automatically. I'm afraid that we do not have control over the value parsing. A possible solution would be to convert the values manually before exporting.
Regards,
Daniel
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.