drop down not visible for the last row

[jeanmarc78]

hello,
i have an handsontable with drop down list,
if i go to the last row , the drop down list is truncated.
regards
jm

http://jsfiddle.net/jeanmarc/81f0x1u6/

[AMBudnik]

Confirmed. Thanks for sharing @jeanmarc78

[krzysztofspilka]

@AMBudnik That's going to be a HUGE refactor of all editors. We'll start it next week and according to our roadmap it should be finished till the end of March. (edited on April 11)

[AMBudnik]

May have an impact on #2380

[krzysztofspilka]

From now on the dropdown will open to the top if there're too little space below it. This is just a workaround before we fully refactor the editors' code.

[Vinitha07ec]

But if the dropdown contains more values then we need to scroll the entire handsontable container to view the full options.Could you please work on this

[mariusk]

I'll just add another opinion on this. Using multiple handsontable instances on one page with autocomplete just isn't working. And it doesn't seem like something that is easily fixed by twiddling around z-index values in css files either. I haven't taken the time to figure out why, but I'm guessing there are hardcoded z-index values being set on dynamic elements like autocomplete tables. It's also painful on a more generic level, where table headers has a tendency to appear on top of other stuff. While I believe the latter may be solvable with documentation, I doubt the former can.

[AMBudnik]

@mariusk thanks for sharing. I created a new issue of your comment at #3443

[hbeita]

Hello, I still have this issue due the fact that spaceBelow can be equal to spaceAbove on that scenario, the dropdown options are still unable to read, in this case handsontable should flip the dropdown up so the evaluation here should be if (flipNeeded && spaceAbove >= spaceBelow) instead of (flipNeeded && spaceAbove > spaceBelow), here is the commit line for the above suggestion change: autocomplete flip upwards commit

e.g:

• with the current release if (flipNeeded && spaceAbove > spaceBelow)
  
• implementing if (flipNeeded && spaceAbove >= spaceBelow)
  

[AMBudnik]

@hgarciab could you share a demo where we will be able to replicate the issue?

ps. while I was testing this solution I came across this situation: http://jsbin.com/rojaroluqi/1/edit?js,output

I think that the dropdown menu should open above the cell not create an extra space on the page, but waiting for your opinion.

[hbeita]

Sure @AMBudnik, here is the demo, hope this helps: https://jsfiddle.net/BeitaHere/6hf52e6x/7/, and yes I think would be better not use space that doesn't exists on the screen.

[AMBudnik]

thanks for sharing @hgarciab
I'm reopening this issue. We have to test it more.

[AMBudnik]

after fixing this issue we should also check this one: #3443

[jaredbaszler]

I just ran into this issue today as we recently implemented a horizontal scroll bar on our HOT. We only start with a single row and the main purpose is to let users add the x-amount of rows they need. Which means the row they are working on is always at the bottom. So this issue is compounded by that fact. Please fix soon:

[AMBudnik]

Current topic for this issue: #3435