Since recently we noticed when a user creates a Static Worksheet from user interface on any entity, it has a fixed column width on all columns (e.g 41.29 or 295 pixels). They won't auto adjust based on cell values.
But 'Advanced Find' doesn't have this issue. Excel column width changes based on the cell value.
Anyone knows a fix for this?
I think we may be talking about two different things. The problem I have currently is that the column width in exported excel files defaults to 41.4 pixels. That behavior started recently. If I export the same data from Advanced Find, the column widths are 13.4, the way they used to be. The difference is significant, because 41.4 is too wide for me to see enough data, forcing the extra step of adjusting column widths in Excel.
That works, thanks for the suggestion. It still requires extra clicks, however--I either have to export and adjust column width in Excel, or navigate to Advanced Find and export from there. I'm hoping for a solution that will allow me to do it directly from the View, the way it used to work. Strange that it has changed.
Select the Column A and go to “Data” tab and click “Text To Column” option. Select the Fixed Width Format option and click “Next”. Here you would see in grid that data is separated by some columns.
Regards,
J Wick
I am experiencing the same problem. Have you found a solution?
Hi Ric,
Maybe you can open one ticket for Microsoft:
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,387
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
