Excel export issue with dates (Chrome)

[Joccd]

Hello,

I have an issue about excel export with dates (only with chrome). I send 05/02/2018 (dd/MM/yyyy) 00:00:00 to the grid and this is the result in the excel file :

 

05/02/2018 00:00:21 (UTC+1)

05/02/2018 00:00:33 (UTC+5)

04/02/2018 23:59:22 (UTC-10)

 

My Workbook object is correct and it looks like the problem with seconds comes from the toDataURL function. It returns a different result between Firefox/Internet Explorer and Chrome.

 

Any Idea ?

Jef

[Alex Hajigeorgieva]

Hi, Jef,

Thank you very much for getting in touch to report your observations of the difference found in Chrome.

We are aware of some fundamental changes that Chrome has enforced since version 67 and this seems to be one of the changes that has an impact on the dates in the Excel export.

https://stackoverflow.com/questions/50840885/new-date-broken-on-chrome-67/50841568#50841568
https://stackoverflow.com/questions/50609860/browsers-time-zones-chrome-67-error/50610030#50610030

At this time, we are working towards identifying the concrete cause and will update this thread as soon as I know more about it.

I apologise for any inconvenience this may be causing.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[Alex Hajigeorgieva]

Hi, Joffrey,

Could you please check the windows build and version on the machine which exports the wrong dates?

The  1709 version build 16299.371, 1803 version OS build 17134.112 & 17134.48 does not reproduce it, however, we were able to reproduce it with the earlier version 1703 build 15063.0.

Thank you in advance for your assistance in this matter.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[Alex Hajigeorgieva]

Hello, Joffrey,

We have discussed this with the team and I am pleased to inform you that we will implement a special behaviour in our source code to assist our clients with the change which Chrome 67 new Date standard introduced.

I have now logged an issue and assigned a developer to work on it. It will be looked at with high priority and we have included it in our immediate tasks.

Here is it for your reference so you may watch its progress as well:

https://github.com/telerik/kendo-ui-core/issues/4338

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[Acacus]

We're still encountering the issue where datetime values are incorrectly adjusted during Excel export in Chrome, as initially reported. Specifically, the time component of dates is being altered, showing discrepancies in the exported Excel file compared to the original data displayed in the Kendo UI Grid.
could you please provide an update on the resolution of the issue related to the Excel export in Chrome? Where can we find the solution?"

[Eyup]

Hi Acacus,

Thank you for writing to us. I hope you are doing well.

Can I ask you to open a formal support ticket and send us a basic dojo, REPL or MVC sample to demonstrate the issue so we can investigate it deeper locally?