This is a migrated thread and some comments may be shown as answers.

Excel export issue with dates (Chrome)

3 Answers 503 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Joccd
Top achievements
Rank 1
Joccd asked on 18 Jun 2018, 12:27 PM

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

Sort by
0
Alex Hajigeorgieva
Telerik team
answered on 20 Jun 2018, 12:53 PM
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
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
Alex Hajigeorgieva
Telerik team
answered on 22 Jun 2018, 07:54 AM
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
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
Alex Hajigeorgieva
Telerik team
answered on 25 Jun 2018, 03:03 PM
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
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
Top achievements
Rank 1
commented on 27 Dec 2023, 07:18 AM | edited

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
Telerik team
commented on 28 Dec 2023, 11:03 AM

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?

Tags
Grid
Asked by
Joccd
Top achievements
Rank 1
Answers by
Alex Hajigeorgieva
Telerik team
Share this question
or