1 Answer, 1 is accepted
0
Accepted
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.
Our thoughts here at Progress are with those affected by the outbreak.