Why is the column width of the export extra wide when exporting a date type?
https://stackblitz.com/edit/react-tfamno
1 Answer, 1 is accepted
0
Accepted
Stefan
Telerik team
answered on 12 May 2020, 01:34 PM
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:
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.