Two sheets with different amount of rows and cols

Tags: #<Tag:0x00007f0b0097ca68> #<Tag:0x00007f0b0097c888>

How can I add two sheets with different rows and cols amount?
I need display main sheet to user and have one more hidden with formulas for logic (service sheet).
If I just create two sheets with HyperFormula and trying to switch between them, I see the same amount of rows and cols. But it redundant because my service sheet have much less used cells than main sheet.

Hi @denial.trombol

What you need to do is basically create two different instances of Handsontable with different configuration and dataset. Here’s a good example with HyperFormula:

I could not even imagine that different Handontable instances could work with the same HyperFormula instance.
Thank you.


I’m glad that it worked for you. I will close this topic now.