IMPROVE. RadGridView - GridViewSpreadExport doesn't export dates in date+time format with any of the available DisplayFormatTypes

Completed

Last Updated: 05 Sep 2017 09:42 by ADMIN

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. 

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)

Create an account Log In

View

Type

Status