Saw this in Google search few months ago, and has "worked", but NOT all the
time ... especially when Column Entry is "long" (around 30 or more characters).
From Google search ...
1. Excel columns with inconsistent width:
We could specify fixed column width using 'Size & Overflow' property to have a uniform look, but the moment we export to excel, the fixed width applied in the report does not reflect in excel.
Columns may stretch or shrink inconsistently.
To avoid this behavior, do not use 'Size and Overflow' on column header or body, but use it on the data item inside the column body by unlocking the report.
Any known way of "guaranteeing" setting a "long entry" Column Width so any characters longer than the setting will expand the column entry by making a longer row height?
TIA, Bob