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

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.

10
10 votes

Open For Voting · Last Updated

Comments

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 5

    totally support that idea, thanks, @Michael Gerrard !

  • 😯🤩

  • Sergi Fernández
    Sergi Fernández Active Partner, Community Captain
    100 Up Votes 10 Comments Second Anniversary 5 Likes

    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,

  • @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.