[9.0.1+] Uncaught TypeError: Cannot read property 'validateCell' of undefined

[AMBudnik]

Description

As mentioned by @haraleib when data to a virtual sheet is added Handsontable tries to validate that as well. As the second sheet is not an instance of Handsontable we get an error.

Issue transferred from discussion #8263

^{Originally posted by haraleib June 22, 2021}
Encountered the exception "Uncaught TypeError: Cannot read property 'validateCell' of undefined" with handsontable version 9.0.1, which works in version 9.0.0.

When using two sheets inside one hyperformula instance, I get this Exception if the second sheet has formulas which reference to the first sheet.

jsfiddle Example: https://jsfiddle.net/1yrfujg8/1/

How to reproduce it in the provided example:

• Open Browser-Debugger
• Type in a value, as mentioned in the screenshot

Exception in the browser debugger

[haraleib]

Is there any new information for this bug? Unfortunately this is a regression for me to update from V9 to a newer Version of Handsontable.

[AMBudnik]

Hi @haraleib this issue hasn't been scheduled yet. If you have a short deadline on that specific use case please email me at support@handsontable.com

[vipina1019]

any update on this issue?

[haraleib]

Tried to update today to V11.1.0 to see if it is fixed indirectly through some other issues, but as expected the problem is still there.
I think to encourage/improve the usage of hyperformula with handsontable it should be scheduled for one of the next releases, as this regression makes it impossible to update,.. unfortunately.

[AMBudnik]

The v12 and v12.1. are already fully booked. But if you would need to get this issue solved now we can offer consulting services, as we have a separate team there. If you are interested @vipina1019 @haraleib please contact me at support@handsontable.com

[sequba]

In my opinion the root cause of this problem is that sheet2 (in jsfiddle example) is not attached to any hot instance while Formulas Plugin tries to call hot methods on it.

I didn't test it but it should be sufficient to add the following code to this line

if (!hot) {
  return;
}

[haraleib]

In my opinion the root cause of this problem is that sheet2 (in jsfiddle example) is not attached to any hot instance while Formulas Plugin tries to call hot methods on it.

I didn't test it but it should be sufficient to add the following code to this line

if (!hot) {
  return;
}

@AMBudnik I tested the fix and the fix works as expected. Already using it in production.
Would be cool if the fix find its way in the official release soon :-)

[AMBudnik]

Thank you for feedback, @haraleib
The issues are added to the next milestone. If there won't be any unexpected changes in our plans we will add the changes to the next version after v12.0. I will keep you updated.

[haraleib]

Sounds great, thank you for your answer @AMBudnik

[aninde]

Demo with v12.0.1 https://jsfiddle.net/jLf09mz5/1/ still didn't work, but with a different warning, however e2e test with this case passed. @budnix can you check it?

[budnix]

Demo with v12.0.1 https://jsfiddle.net/jLf09mz5/1/ still didn't work, but with a different warning, however e2e test with this case passed. @budnix can you check it?

The error is related to the wrong HF API usage. Fixed demo https://jsfiddle.net/tL04mqnv/.

[aninde]

@budnix thank you for spotting that :)

[AMBudnik]

@haraleib @vipina1019 we just released Handsontable v12.0.1 with fixes for this issue.

Here https://handsontable.com/docs/release-notes/ is the full list of changes in the latest patch.