distal-attribute
distal-attribute
distal-attribute
distal-attribute

Turning off column autowidth

User, date Message
Written by fitzwilberforce
5 years ago
Category: Feature discussion
5 posts since Wed, 16 Dec 09
I love using HeidiSQL, but the one thing driving me kind of crazy is that after entering information in the grid view and updating the record, the columns automatically resize to fit the window width. With a lot of columns, that means I usually can't see the data. If there's a preference setting for this, I haven't found it.
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
There is no preference option for that.

I have just removed the one call to AutoCalcColWidth() in the OnEdited event, see r2877. Should reduce the annoyance factor.
Written by fitzwilberforce
5 years ago
5 posts since Wed, 16 Dec 09
Wow, that was quick!

Works perfectly now. Thanks for a great application.
Written by AliG
3 years ago
20 posts since Tue, 12 Jan 10
Hi,
is this function still available somehow?

Furthermore, haven't you planned to save column info (size, position) for each table?

THX
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
Column auto sizing is still built in, yes. Column selection is saved for each table, across sessions. But the widths of columns are auto-calculated each time you access a table, as the content width of cells vary based on filtering and sorting.
Written by AliG
3 years ago
20 posts since Tue, 12 Jan 10
I would prefer to have some option to save (and override) the auto-calculated width, because I could see all the columns without scrollbars ;)

for example ... I have date like 2010-01-01 and the width of the column is 15-20px (0,5 cm) bigger than it is necessary ... and if I have 20 such columns :)
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
I would prefer to adjust the automatic calculation instead of leaving the effort to the user. Now that you mention the date columns I see that too - will check that.
Written by lemon_juice
3 years ago
127 posts since Tue, 29 Jun 10
I agree with AliG. Auto width calculation is fine but it will never be able to always guess how the user wants to view the data. Therefore, saved column widths would be the way to go. It wouldn't be leaving effort to the user because it could be turned off by default. Anyway, in my experience it actually takes more effort to adjust the widths every time heidi recalculates them.
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
Well, then why not optimize the current calculation, before making a new "manual" feature? The above mentioned pixels are probably more a bug than intentionally I guess.
Written by lemon_juice
3 years ago
127 posts since Tue, 29 Jun 10
It's not only date columns that are slightly wider than necessary - it can be because some space is reserved for the cell editing button (...) or control (up and down arrows for dates). In this case I don't think it's possible to squeeze them much.

But... sometimes the extra space is good for readablity because having all columns cramped close with almost no space may look like a mess. Sometimes we need to be able to get rid of the spaces to see more columns. What I'm getting at is you will never be able to make an auto-calculation that will please all users and fit all cases. Correcting date column widths is just a minor problem (if it's a problem at all) while the real solution is remembering user-defined widths - then such small auto-width miscalculations won't matter at all.

For example, I often like to see only the first 10-15 characters of a varchar or text field because that's enough. If a column is a username I usually want to see all text. But if a column contains a 64-character hexadecimal hash then it's useless for me to see it in full, just first 10 characters is enough. I could give you plenty of other examples like that. No program will ever be able to guess all that for the user, that's why I think user-defined widths is the real solution.
Written by AliG
3 years ago
20 posts since Tue, 12 Jan 10
yes, I have the same opinion ...

auto calculation can remain there, but there could be an additonal button (in the place where you right click the column) to save widths ;)
Written by niente
3 years ago
1 posts since Wed, 07 Dec 11
I have the same problem. I spend more time in resizing columns than in other DB operations. It's almost ridiculous that Heidi hasn't still implemented the "save columns width" button. unhappy

The optimal solution would be to save widths in memory during the same session even if I switch between tables, plus an "autosize" button to reset them to default calculated widths.
 

Please login to leave a reply, or register at first.