Does pe:sheet support nested headers?

Question

I am using the PrimeFaces Extensions Sheet component in different contexts and I need different functionalities. I stumbled upon the requirement of nested headers. I see that the underlying component supports this, but I am not sure how to do it with the pe:sheet component.

I already tried setting up the extender cfg property and also tried updating the hot instance, but it does not seem to work.

function sheetExtender(){
this.cfg.colHeaders = true;
this.cfg.rowHeaders = true;
this.cfg.nestedHeaders: [
                    ["", {label:"my label", colspan:3}],
                    ["A", "B", "C", "D"]
                ]

And also tried the following:

PF('widgetName').ht.updateSettings({
colHeaders: true,
rowHeaders: true,
nestedHeaders: [
["", {label:"my label", colspan:3}],
["A", "B", "C", "D"]
]
})

I was hoping that one of these approaches would trigger the underlying HandsonTable component to draw nested headers. If non of these work, what would be a workaround for it?

Hmmm tweaking the JSON should be possible but I have never tried messing with the headers before. Are you sure your JSON syntax is correct for what you are trying to do? — Melloware, Jun 25 '19 at 23:31
According to their documentation yes. Here is a link for it: [headers](https://handsontable.com/docs/7.1.0/Options.html#nestedHeaders) — adjiandov, Jun 26 '19 at 11:00

score 2 · Accepted Answer · answered Jun 26 '19 at 13:12

Nested Headers is a HandsonTable PRO only option. This means it is not included in the 6.2.2 Community Edition that PrimeFaces Extensions Sheet uses and therefore is not available to be used.

HandsonTable Pricing Info

We cannot upgrade to 7.1.0 because its a Non-Commerical License. 6.2.2 was the last Open Source MIT Licensed version. Handsontable drops open source for a non-commercial license

Does pe:sheet support nested headers?

1 Answers1