Grid enhancements

ansgar's profile image ansgar posted 14 years ago in News Permalink
Both grids in "Data" and "Query" tabs now support a variable row height. Very useful if you like to see more than the first line of text in table cells at once. Just increase the option "Lines of text in grid rows" in "Tools" > "Preferences" > "Data" to a higher value.



Above the data grid, you will notice two new buttons for "Next" and "Show all". The grid loads table data in chunks of 1,000 rows. So, "Next" loads the next chunk of 1,000 rows, and "Show all" loads the entire table, up to a maximum of 100,000 rows. Both values are customizable via "Tools" > "Preferences" > "Data".

The good thing is: normally you won't need to click any of these two buttons, because:
A) "Next" is automatically executed when you have the last row focused and the press the PageDown key. So, if you hold down the PgDn key, you will see Heidi loads data on demand in a larger table.
B) Both buttons have shortcuts. "Next": Ctrl+Alt+PgDn, "Show all": Ctrl+Alt+End.
1 attachment(s):
  • datagrid_rowheight
[expired user #4720]'s profile image [expired user #4720] posted 14 years ago Permalink
No variable heightunhappyAll lines have the same height after this option was set.
ansgar's profile image ansgar posted 14 years ago Permalink
There was a bug which required you to restart Heidi after having set this option. I have fixed that afterwards, so be sure you have the latest build. In r3132 this is definitely working as expected.
[expired user #4720]'s profile image [expired user #4720] posted 14 years ago Permalink
Perhaps I didn't understood, but topic on homepage starts with "Both grids in "Data" and "Query" tabs now support a variable row height..."
I thought that variable height means, that grid lines with short data (string) have one-line height. And all other lines have height with data-height value.
[expired user #4720]'s profile image [expired user #4720] posted 14 years ago Permalink
... so works as css max-height wink
ansgar's profile image ansgar posted 14 years ago Permalink
Ah no, that was bad wording in my posting. Row height is not auto-adjusted for text lengths, it's just hard set by your preference option.

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