InfoQube IM - Community

Submitted by WayneK on 2016/04/15 17:01

I've started using large grids with many columns and with cells containing varying amounts of text. There are some issues with how horizontal scrolling is done that I'd like to discuss.

As you scroll horizontally, the grid view changes dynamically based on the height of the cells displayed. This means that the location of your selected grid row jumps up, down, and all over the place as cells of varying heights pass into and out of view. It's even possible for your selected row to disappear completely then reappear again.

I guess the advantage of this behavior is it allows you to display more rows at a time if you're showing a section of your grid that has only cells with one or two lines. But I don't think this advantage offsets the jumping around behavior, which I find strange and disorienting. Maybe there are other advgs/disadvgs that I'm not seeing.

The other option would be to display the full height of the row equal to the height of the tallest cell, whether that cell is in view or not. That's what Excel does.

What are your thoughts on this?

As a related issue: also not sure I like the default behavior when you scroll to the end of a row. I'd prefer it to stop at the last cell instead of jumping to the next row.

Wayne

Comments

I've never seen this because I don't have that many columns displayed, just the idea of the cell height jumping around is pretty funny and I think it's a no-brainer it shouldn't behave that way. I'm guessing it's just never been mentioned as an issue since most don't have that many columns so Pierre has never addressed it.

[quote=David_H]

I'm guessing it's just never been mentioned as an issue since most don't have that many columns so Pierre has never addressed it.

[/quote]

Just for fun: I actually mentioned it -- I have many grids with 10s of columns -- but a loooonnng time ago. February 23, 2008 (yep). I'm getting old.

I wrote that note: Bug : While scrolling horizontally , multiline rows height adapt and "shrink" to the new visible fields' height (for example : when the item's fields are multiline, and other fields/columns are single line). Makes reading and editing hard.

Now, I got used to it, and I don't care anymore. Probably some grid limitation.

But it doesn't mean it wouldn't be better if it was "fixed".

Disclaimer: "Testing IQ with the most advanced/complicated IQBase in the world". I.e. slower than average.

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=WayneK]

The other option would be to display the full height of the row equal to the height of the tallest cell, whether that cell is in view or not. That's what Excel does.

[/quote]

I'd like this too. If the user needs to see more rows, just switch word wrap off.

Would also be nice if there was a full row "word wrap off" option that wouldn't affect column specific settings when toggled (maybe there is, but I don't think so)

[quote=WayneK]

As a related issue: also not sure I like the default behavior when you scroll to the end of a row. I'd prefer it to stop at the last cell instead of jumping to the next row.

[/quote]

Same here.

Good suggestions IMO.

Disclaimer: "Testing IQ with the most advanced/complicated IQBase in the world". I.e. slower than average.

Windows 8.1

CPU: Intel i5 2.6ghz

Thanks, Armando. As you said, not a big issue at all but it definitely "jumps" out at you when you go back and forth working on a grid.

Wayne

Work around I've started using:

1) I keep the leftmost column (item) fixed and in view.

2) I add blank rows to this item equal to the max. number of rows in other cells for that item.

That keeps the row at a fixed height no matter what section of the grid you're viewing, and you can scroll back and forth smoothly.

Wayne

Win 7, 64 bit Cyberpower Model 1, C Series (2011) 16 GB RAM

27" Samsung S27A350H, 24" ASUS VW242H 1920x1080

[quote=WayneK]

As you scroll horizontally, the grid view changes dynamically based on the height of the cells displayed. This means that the location of your selected grid row jumps up, down, and all over the place as cells of varying heights pass into and out of view. It's even possible for your selected row to disappear completely then reappear again.
As a related issue: also not sure I like the default behavior when you scroll to the end of a row. I'd prefer it to stop at the last cell instead of jumping to the next row.

[/quote]

I was able to recreate the issue and will contact the grid manufacturer. This happens only when you have move than one column set to Wordwrap... perhaps only set the Item column to wordwrap ?
This has always been like this. No recent change. That said, I can certainly add some options to control this...

HTH !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

... perhaps only set the Item column to wordwrap ?

[/quote]

It's often not possible. But I got used to the rows shrinking and growing. :)

Disclaimer: "Testing IQ with the most advanced/complicated IQBase in the world". I.e. slower than average.

Windows 8.1

CPU: Intel i5 2.6ghz