[Bug]: A 'Sheet size limit exceeded' error is being thrown when using multiple Hot instances in separate React components with a single Hyperformula instance. about handsontable HOT 2 OPEN

Hi @wave-light

Thank you for reporting this. I checked the issue, and it's related to the HyperFormula itself, and the limit set for maxRows in the engine is too small.

We have a similar issue reported here: handsontable/hyperformula#1185.

In this case, the same problem was found in the maxColumns, but I believe the reason is the same. I will report it internally and let you know when we have more information on the possible timeline for the fix.

from handsontable.

The cause of the error

The Formulas.updatePlugin method passes the maxRows and maxColumns settings to the HyperFormula engine. But in HyperFormula the maxRows and maxColumns config options are global and hold for all sheets.

Relevant formulas plugin code:

Recommended solution

maxRows and maxColumns settings in Handsontable seem to control the visual layer (the number of rows and columns displayed), whereas in HyperFormula, the maxRows and maxColumns config options were introduced for performance reasons. In my opinion, Handsontable should not pass these settings to HyperFormula.

To fix the issue, it should be enough to remove lines 41 and 42 from the handsontable/src/plugins/formulas/engine/settings.js file:

from handsontable.