Auto-size column width to ensure the value is displayed in full

Michael Gerrard · 2024-11-05T14:38:39+00:00

There was an error rendering this rich post.

For tables with many columns of numbers, the default width of those columns maybe too small, meaning the whole number is not fully visible. The user could resize columns themselves but this is tedious.

As a default, could the column sizes be set to auto-size based on the largest data value? Just like in Excel. For example, a column has the following:

5,000,000

234,000,000

The width of the column would be wider enough to show 234,000,000.

Find more posts tagged with

Open For Voting

Status: Open For Voting

Comments

Helmut Heimann

totally support that idea, thanks, @Michael Gerrard !

Carlos Eduardo Meneses Maran

😯🤩

Sergi Fernández

Great idea @Michael Gerrard! Would this functionality fit the longest data of the table, or would it also fit the title, in case the title is longer than the data?

In addition to setting columns to auto-size by default, it would be incredibly useful to have an Excel-style functionality where double-clicking the edge of a column automatically resizes it to fit the longest content. Also, an option to autofit all columns by selecting them and double-clicking a column margin, just like in Excel, would make it even easier to optimize table readability with minimal effort.

Best regards,

Michael Gerrard

@Sergi Fernández I would think the title should be independent of this functionality. The title should already be set to be reasonable. It would make sense if there was a minimum column width. The auto-size would not auto-size to a size smaller than the minimum column width.

The other features you mentioned sound good too, although I prefer it when the user doesn't have to know or do anything.

wdeer

This would be a big win! Please incorporate this into a release soon.