grid excel export date column width

2 posts, 1 answers
  1. Daniel
    Daniel avatar
    14 posts
    Member since:
    Apr 2020

    Posted 11 May 2020 Link to this post

    Hi,

    Why is the column width of the export extra wide when exporting a date type?

     

    https://stackblitz.com/edit/react-tfamno

     

     

  2. Answer
    Stefan
    Admin
    Stefan avatar
    3034 posts

    Posted 12 May 2020 Link to this post

    Hello, Daniel,

    Thank you for your example.

    This occurs as the column will expand based on the content and it this case the content is "Tue May 12 2020 08:05:34 GMT+0300 (Eastern European Summer Time)". Excel just formats it as a date automatically. We set the width of the generated columns based on the actual content passed to it, no based on how it will be formated, as every Excel is different and can format it differently based on the region and other settings.

    In this case, we can set a width to the column to ensure that it won't be that large:

    https://stackblitz.com/edit/react-tfamno-rdopx4?file=app%2Fmain.jsx

    Regards,
    Stefan
    Progress Telerik

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
Back to Top