Handsontable: Fixing more columns than visible in the viewport breaks scrolling

[AMBudnik]

Description

Fixing more columns than visible in the viewport breaks scrolling.

Steps to reproduce

1. Scroll to column Z
2. Freeze the column via custom context menu option
3. Try to scroll the fixed area.

You get only the cells visible in the viewport or an empty space.

Demo

http://jsfiddle.net/3bn30mLq/1/

Your environment

• Handsontable version: 1.10.2/0.31.2
• Browser Name and version: Chrome 57
• Operating System: Windows 10

[issue transferred from [Forum#1115](https://forum.handsontable.com/t/freeze-panes-bug-when-out-of-viewport/1115)]

[rbarato]

Hi, any updates on this? 👍

[AMBudnik]

Sorry to say @rbarato
but I do not see this issue scheduled for Q2.

[rbarato]

Ok, thanks for the update.

[AMBudnik]

Unfortunately not @pensula but the issue that you have reported will possibly help us to solve this one https://github.com/handsontable/handsontable/issues/4591 (only the axis is changed).

[rbarato]

Hi all, any updates on the milestone? Should we expect this fix to be included in the next release since it has been give the "fixing" label? Thanks

[AMBudnik]

Hi @rbarato
sorry for a misleading label. The fixing related to the functionality called fixing, and not the actual process of repair.

[rbarato]

Hi @AMBudnik, sorry for the misconception. Anyway, is there any expected release date?

[AMBudnik]

Currently, we are preparing for the next release but after that, I can try to review the issue and check if's something easy to fix.

[AMBudnik]

Hi @rbarato

the issue seems to be gone in v 2.0.0 http://jsfiddle.net/d1ca94p9/ can you let me know if it also works for you.

[rbarato]

Hi @AMBudnik

Made the necessary update in the fiddle http://jsfiddle.net/d1ca94p9/1/ (as getSelected() changed) but the issue still persists, now I can scroll partially the table if frozen after viewport...

Maybe should be opened as a new bug?

[AMBudnik]

Can I ask you to record it @rbarato? I do not see anything buggy

[rbarato]

Here it is (http://jsfiddle.net/d1ca94p9/2/)

[AMBudnik]

Thank you for the demo. I can't test it right now but can you check if changing hot.getSelected() to hot.getSelectedLast() solves the issue?

[rbarato]

@AMBudnik same result 😢 http://jsfiddle.net/d1ca94p9/3/

[AMBudnik]

I do not have the same result with the following demo. I have tested it on Chrome 65 on Windows 10

[rbarato]

@AMBudnik Could you please record it? I'm using Chrome 65 on MacOS Sierra

[AMBudnik]

Oh.. I got it :( I've scrolled to the O column having L as a last visible and the viewport do not change http://jsfiddle.net/dpgsetzt/

[rbarato]

Hey guys, what's the current status on this?

Thanks!

[AMBudnik]

Sorry @rbarato

I do not have any news. I will ask our CTO to take a look at this issue next week on a devs meeting

[rbarato]

Ok @AMBudnik, thanks for moving it forward

[AMBudnik]

It looks like the October's milestone is already too big to add a new bug. However I have left myself a note to mention this bug on the next planning meeting

[rbarato]

Hi @AMBudnik, any news on the next milestone? I tried to find this at trello board but I couldn't (I keep asking about this issue because it's crucial to our costumer)

Thanks!

[AMBudnik]

To be honest this subject is really problematic. Our developer checked the behavior for Google Sheets and they block an ability to freeze more columns than visible.
However, I agree that we cannot hold the to be discussed label for so long.
Can you tell me what would be an expected result in this situation (my first video)?

[aninde]

This issue is still replicable on 7.2.2 and 8.0.0-beta.1 version. All data in a table are overlayed when you resized a frozen or fixed column to be widther than viewport.
Additionally, a small square of the bottom scroll is missing.

Steps to reproduce

1. Open demo
2. Freeze the first column.
3. Resized it to be widther than viewport.