This is a migrated thread and some comments may be shown as answers.

RadGrid Export to Excel Modifies DateTime data.

1 Answer 93 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Daniel Gioulakis
Top achievements
Rank 1
Daniel Gioulakis asked on 27 Apr 2012, 02:40 PM
I have several RadGrids with DateTime columns in which the dates are presented in the client's local time. The data is returned from the database in UTC and converted during binding.  When I export to Pdf or Word, it correctly uses the client's time.  However, when exporting to Excel, the times are incorrectly shown in what I believe is the UTC time.

My export settings are set to ExcelML and ExportDataOnly = true.

Is this a known bug?

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 02 May 2012, 11:32 AM
Hello Daniel,

When using the ExcelML export, RadGrid takes the data directly from your datasource so any changes you made at runtime will be ignored. If you need to modify these dates, you have to use the ExcelMLRowCreated or ExcelMLWorkbookCreated events.

Kind regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Daniel Gioulakis
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or