Hello,
I want to use handsontable combined with hyperformula to automatically perform some calculations when data are loaded. I decided to split my table in two to enable saving the data in a JSON file: the left side to fill in data and the right side for formulas.
My issue is that the columns overlap when I scroll vertically on my page after loading data. This issue only appears when I have more than one handsontable on my page.
Thank you for contacting us. I am unable to reproduce this issue. I tried with several JSON files and I can’t load the data at all Can you please send the file you were working with?
The tables look fine for me when I load the data. The overlap occurs when I scroll down the page. Did you try? I can produce this issue with the JSFiddle I send you.
Yes, I tried with the scrolling and it still looks fine. Can you please tell me what browser you use, and do you have any browser or OS scaling turn on?
I was able to reproduce it and find the reason. It appears that when the same HyperFormula instance is used in two different instances of Handsontable it wrongly recalculates the table dimensions on scroll. You can check that in your example when you comment out the formulas configuration or define two separate instances of HyperFormula, load the data and scroll everything will be rendered correctly. I will report it internally for further investigation and let you know once it’s fixed.
I tried to create a function that generates a new instance of HyperFormula and provides it as input for the engine option. This solution doesn’t work. The formula in the handsontable returns the error #REF!. It looks like the tables don’t communicate with each other if they are not in the same instance.
Yes, they need to operate on the same HyperFormula instance level, just different sheets. That’s why this bug has to be solved in our codebase. I’m afraid there is not workaround for this, but if I find something I’ll let you know.
Hello, I don’t know if this helps, but it seems that resizing the web page window allows the table’s columns to retrieve the correct dimension. It even works when resizing the result window in JSFiddle.
Is there any update on this issue? Can you provide an estimated waiting time for the problem to be solved? I really need this functionality for my project.