Completed
Last Updated: 05 Sep 2017 09:42 by ADMIN
ADMIN
Dess | Tech Support Engineer, Sr.
Created on: 17 Aug 2017 08:27
Category: GridView
Type: Bug Report
3
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. 

Workaround: 
GridViewDateTimeColumn columnDateTime = this.radGridView1.Columns["Date"] as GridViewDateTimeColumn;
columnDateTime.ExcelExportType = DisplayFormatType.Custom; 
columnDateTime.ExcelExportFormatString  = "dd/MM/yyyy hh:mm:ss";
1 comment
ADMIN
Ralitsa
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 (http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/format-codes)