Last Updated: 05 Sep 2017 09:42 by ADMIN
Dess | Tech Support Engineer, Principal
Created on: 17 Aug 2017 08:27
Category: GridView
Type: Bug Report
IMPROVE. RadGridView - GridViewSpreadExport doesn't export dates in date+time format with any of the available DisplayFormatTypes
Currently, DisplayFormatType.GeneralDate, DisplayFormatType.ShortDate, DisplayFormatType.MediumDate all return culture's DateTimeFormat.ShortDatePattern. 

GridViewDateTimeColumn columnDateTime = this.radGridView1.Columns["Date"] as GridViewDateTimeColumn;
columnDateTime.ExcelExportType = DisplayFormatType.Custom; 
columnDateTime.ExcelExportFormatString  = "dd/MM/yyyy hh:mm:ss";
1 comment
Posted on: 05 Sep 2017 09:41
We will add two predefined date time formats ShortDateTime and LongDateTime with Telerik UI for WinForms R3 2017. Bear in mind that you can set the ExcelExportType property of the specific column to Custom and specify the ExcelExportFormatString property with the desired format. The following help article is quite useful for specifying the desired format: Format Codes (