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

Categories:

General

All responses (1)

Answers (0)

André Arnaud de Cal... 287,696 Super User on at

Like (0)

Report

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

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.