Radgrid export to excel date format issue while using BiffExporting format

[Hiren]

Hello,

I have issue with date format while export to excel the RadGrid,

I have set  ExportSettings-Excel-Format="Biff" format to avoid the warning message while open the excel sheet.

Now i have DateTime column in my RadGrid and i am exporting Radgrid view , but i am not able able change the datetime format while exporting to excel.

The format of DOS, follow up date, appt time and pick up time when exporting to excel (pic 2) should have the same format as in the (pic 1)

For more details please check the attach screen shot.

Let me know if you required more information.

Awaiting for the positive and quick response.

Thanks,
Hiren

[Kostadin]

Hi Hiren,

I tried to replicate the issue but to no avail. Note that from Q1 2013 SP1 the DataFormatString of the RadGrid columns is applied to the exported file when using BIFF format. I prepared a small sample and attached to this forum thread. Please give it a try and let me know how it differs from your real setup.

Kind regards,
Kostadin
the Telerik team

[Hiren]

Hello Kostadin,

I am using the telerik version 2012.2.821.40.

Can you please  provide the dll for the Q1 2013 SP1 for testing ?

If it is working then i can download the hot fix.

Thanks
Hiren

[Kostadin]

Hi Hiren,

You could log into your account and download the latest version from there. Additionally you could check out the following live example where you could see that the exported file has the same format as the grid.

Kostadin
the Telerik team

[Hans]

Hi Kostadin,

What exact version of RadGrid would that be?

We're using what I believe to be the very latest, Version=2013.1.220.40, and it does not care one bit about the DataFormatString when exporting to BIFF.

I still get only a number in the excel spreadsheet.

        <telerik:GridDateTimeColumn DataField="FailureDate" DataType="System.DateTime" DataFormatString="{0:yyyy-MM-dd}" FilterControlAltText="Filter FailureDate column" HeaderText="FailureDate" ReadOnly="True" SortExpression="FailureDate" UniqueName="FailureDate">
        </telerik:GridDateTimeColumn>

Shows correct in the grid
FailureDate
2010-12-21
2010-12-21

but like this in the excel, BIFF, file:

FailureDate
40533
40533

Regards,
Hans

[Hans]

Hi,

To answer my own question.

DataFormaString works from, at least, 2013.1.403.40 version of the Telerik.Web.UI dll

Regards,
Hans

[Kjell]

DataFormaString not works in Ipad.
In the excel, BIFF, file like: 40533
Works in grid and if i use a computer.

[Kostadin]

Hello Kjell,

Note that the wrong formating of the date values is caused by the default Excel viewer of the iPad. If you are using some other viewer such as Microsoft Excel the format will be applied properly. 

Regards,
Kostadin
Telerik