We were planning to use hyperformula on our table for users to be able to perform calculations. But due to some limitations we are currently not able to proceed. Explaining our use case and issue below.
In an excel sheet when we start to add a formula using the =, excel freezes the rest of the sheet to support the formula. Like when we enter =Sum( then we can select cells or range of cells which then get added to the formula like =Sum(A1:A2 and we complete the operation by closing it with a ‘)’ and press enter. This brings the sheet back to existing state. Since our users are primarily used to using excel, we are unable to leverage the formula feature due to this limitation. Can you pls let us know if we have missed identifying a way to achieve this experience with the current version of handsontable and hyperformula.
Thanks in advance for your support!