Support rowspan setting in nestedHeaders

[DongShi]

Description

By now , it seems we can only set colSpan in nestedHeader, but there are cases we need to merged header cells by row (setting rowSpan > 1).

A common use case is to display columns title with common text, in our case, we need to display three metrics: NorthEast-Revenue, NorthEast-Unit Price and NorthWest-Revenue.

It looks much nicer if we can group together the "Region" part on top of detailed metric name.
Also, in this case, we want the NorthWest-Revenue to be a meged cell (rowspan = 2)

Please be noted many other libs already support this, if HOT can not support this, we have to evaluate other solutions..

two example:
Ant-design table

tabulator

Steps to reproduce

1. Just see my description above

Demo

Your environment

• Handsontable version: Latest
• Browser Name and version: any
• Operating System: any

[AMBudnik]

Thank you for sharing the topic. We have discussed it a couple of times but did not create an official topic to relate to.

Inform Zen, forum

[AMBudnik]

Thank you for sharing this proposition.

I'm moving this topic to Github Discussions. And I welcome everyone to discuss this functionality and share your feedback.
See you there!

[sunzhengbo]

Why hasn't it been implemented yet

[AMBudnik]

Absolutely, I hear you. Handling bugs and improving accessibility took precedence over this feature. It's a cool addition, but we had to focus on the urgent stuff first. It's still on our radar, just a bit further down the line. I will definitely let you know as soon as we start working on it.