when exporting to excel for a grid, the columns' width is not properly setup as in grid

(1) Share

Report

Posted on by Daniel Yang

Could anyone explain this for me?

For example, In the [All vendors] form, when clicking right mouse > Export all rows, the data could be export to Excel.
My question is that the column widths is not properly setup as that in grid.
I need to double click my mouse to adjust the widths in Excel.
Why could NOT it automatically be adjusted when exporting the data?
For example, In the [All vendors] form, when clicking right mouse > Export all rows, the data could be export to Excel.
My question is that the column widths is not properly setup as that in grid.
I need to double click my mouse to adjust the widths in Excel.
Why could NOT it automatically be adjusted when exporting the data?

Epecially the Name column, the data are not shown completely.

Columns in grid:

Columns widths in excel after exporting

I have the same question (0)

All responses (2)

Answers (0)

Sort by

André Arnaud de Cal... 305,196 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Daniel,

Excel is not aware of the actual contents that will be copied into the cells. You can use the Dynamics connector and create a template in Excel where you can pre-manage the width. Luckily Excel has the option to quickly adjust the width of the columns.

Was this reply helpful? Yes No
Daniel Yang 66 on at

Like (0)

Report
Copy link

Link copied!

Thanks, André

Was this reply helpful? Yes No