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.
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.
I’m glad that it worked for you. I will close this topic now.