Hello
In my app, I need an ability to switch between two sheets and refer cells from Sheet1 in Sheet2. Just like in google sheets or excel.
I find in docs how to add another sheet and refer cells from first one. But can’t find any topic in documentation regarding switch between displayed sheets.
Can I do it somehow?
Switch between few sheets in Handsontable with HyperFormula
Oh, seems, I found solution.
I can do this with hot.getPlugin('formulas').switchSheet('sheetName')
.
I’m glad that you found the solution.
Please feel free to open a new ticket when needed.