Last Updated: 06 Nov 2021 08:44 by ADMIN
Created on: 15 Jun 2021 13:44
Category: Grid
Type: Feature Request
Export sane column widths for Excel from Grid


Grid exports columns as 0 width unless Grid column widths are specified in px.  This is a terrible experience for users, and specifying grid width in px is terrible when you have users that can be using phones or 4k screens.  Managing Grid for different screen sizes is already hard enough! 

Solution 1: (Good)

The grid should export a default (64px) width for columns that aren't specified in px. Inexperienced Excel users are lost when columns are collapsed, but can easily resize columns as needed when each one is visible!

Solution 2: (Better)

Calculate a width - like [(rem value)*10]px. Even if it isn't perfect it will go a long way to creating something visually pleasing on initial open in Excel.

This item is a duplicate of an already existing item. You can find the original item here:
Marin Bratanov
Posted on: 06 Nov 2021 08:44

Hello Luca,

We'd rather do this once so we have more time to work on more tasks. If we make this change now, we will have to make a breaking change later, and that's something we want to avoid.

Besides, the enhancement is planned for a release that is coming soon.

Marin Bratanov
Progress Telerik

Remote troubleshooting is now easier with Telerik Fiddler Jam. Get the full context to end-users' issues in just three steps! Start your trial here - https://www.telerik.com/fiddler-jam.
Posted on: 05 Nov 2021 14:59

While we wait for a better implementation, why not set a default column width like suggested by Rob?

Why 0 width should be better than whatever other width?

It's a very simple improvement for the current situation!!

Marin Bratanov
Posted on: 15 Jun 2021 17:38

Hello Rob,

You can Follow the implementation of such functionality in the original thread for this: https://feedback.telerik.com/blazor/1478639-excel-export-should-work-with-columns-whose-width-is-not-set-in-pixels. I've added your Vote to it to raise its priority and I will mark this one as a "duplicate" to keep the portal tidy. I have also added your idea to that thread so it will also be reviewed when it is being implemented.

Marin Bratanov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.