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
3 Answers, 1 is accepted
0
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
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
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
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
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
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Acacus
commented on 27 Dec 2023, 07:18 AM
| edited
Top achievements
Rank 1
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?"
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
commented on 28 Dec 2023, 11:03 AM
Telerik team
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?