Dropdown, minRows, visibleRows and columnSummary

Hello,
I have a grid that can sometimes be only 2 rows long, sometimes 20.
2 of my columns are dropdowns
To make sure that I can see what the options are, I set visibleRows to 5 for each dropdown.
That works fine as long as my grid is more than 6 rows long.
What happens when the grid is shorter is that the dropdown does not extend beyond the grid, neither upwards or downwards. So when editing a dropdown in a grid with 2 rows, the dropdown becomes useless.
So that is why I us minRows. I set minRows to 6 and all goes well.
However, using minRows in combination with ColumnSummary generates an unhandled javascript exception in my browser.

Has anyone experienced similar behaviour and can anyone tell me how to :

  • either make dropdown extend beyond the grid boundary
  • either make minRows work in combination with columnSummary

Thank you very much,
Carl

Thank you for sharing the issue report, @carl

I believe that you experience similar outcomes as we do here Handsontable example - JSFiddle - Code Playground

issue

Where it is hard to see the options. (Maybe I pause here and ask if you would rather see a scrollbar for the table DIV to see the option above/below the table or make the table overlap other elements on the website to show the list).

I was able to replicate the issue with minSpareRows here Handsontable example - JSFiddle - Code Playground where when it is used table does not load and we get an error. We haven’t been reported any similar issue. I will report it to the team and contact you as soon as we fix it. Till the issue is officially fixed, do you think that adding an empty array as a new row or calling alter() method to add rows can be a suitable workaround?

In my opinion, the scrollbar can overlap other elements, no problem with that.
At some point I also got a java exception like you report.
The problem I have is that combining a column total and added rows does not work , it gives an error when rendering the table.
I have now removed the column total and work with the added rows without the column total.

Thanks for the support

Thank you for the additional feedback. I updated the issue regarding visibility of the list with a small table and the task with minSpareRows and summaries.

Would you like me to help you use a formula-based workaround till the issue with the summaries is fixed?

Hi @carl

We fixed the issue in Handsontable v16.2.0. Please test it and let me know how it works for you.