Date problem with Excel Export in XP

[Shuja]

I'm added an Excel export option to a grid, which features multiple date columns.

Under Windows 7, IE 11 and Chrome export this data to Excel with no problem, dates appear correctly.

However when trying it from two different Windows XP machines both IE and Chrome export date fields as just the year value (e.g. 2011), which is then formatted as a date, showing a value such as 03/07/1905.

Unfortunately, many of our users are still using XP - is there a solution?

[Atanas Korchev]

Hello Shuja,

Other users have reported problems with dates in older versions of Excel (2007). We will investigate the problem and update this thread once there is progress.

Regards,
Atanas Korchev
Telerik

 

 

[Atanas Korchev]

Hi,

We reproduced the problem and a fix will be available in the next internal build due by the end of the week.

Regards,
Atanas Korchev
Telerik

 

 

[Shuja]

Thanks, I'll try it then.

[Robert]

I'm running into the same issue with Dates when exporting to Excel 2007. Is there a work around?

Thanks
Bob Turner

[Atanas Korchev]

Hi,

The suggested workaround is to install the latest internal build.

Regards,
Atanas Korchev
Telerik

 

 

[Bob]

Has a fix for this been officially released (not an internal build)?

[Atanas Korchev]

Hello Bob,

Yes, this bug is addressed in the latest official release.

Regards,
Atanas Korchev
Telerik

 

 

[Bob]

We are on DLL version 2015.1.318.545.  Is the bug fixed in this version?

One of our users (off-site) sent us an example of this bug from our production site just the other day.  We have no way to reproduce as we don't have Excel 2007.

[Atanas Korchev]

Hi Bob,

Yes, the bug is fixed in that version. Make sure the Kendo UI JS files are the same version.

Regards,
Atanas Korchev
Telerik