Excel export issue with dates (Chrome)

4 posts, 0 answers
  1. Joffrey
    Joffrey avatar
    2 posts
    Member since:
    May 2018

    Posted 18 Jun 2018 Link to this post

    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

  2. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    1054 posts

    Posted 20 Jun 2018 Link to this post

    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.
  3. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    1054 posts

    Posted 22 Jun 2018 Link to this post

    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.
  4. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    1054 posts

    Posted 25 Jun 2018 Link to this post

    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.
Back to Top