Running setCellContents in HyperFormula doesn't update HandsonTable as expected

[david]

I’ve made a simple example on stackblitz:

handsontable - StackBlitz

TLDR; running setCellContents on HyperFormula doesn’t affect the linked HandsonTable unless we run .render() on the table. There’s nothing in the documentation of either noting this behaviour. I figured out the render workaround as I noticed the values applied after resizing my browser. Dumb luck for me.

This Forum thread, and GitHub issue makes me think this is a regression bug? Or maybe it just needs better documentation?

[GH #8391] Hyperfomula, updating cell/formula references which is the proper method?

Hello everyone… I’m using Hyperformula with 2 Hot instances using Vlookups between the instances,… the formula syntaxs works on the loadData of the Hots, but as new rows are inserted into any of the Hots I created a routine to refresh/reset the references of the Vlookup formulas inside the Hots to reflect the new lookup range but is not working using the following: Hot.SetDataAtCell(0,5,’=Vlookup(B5,Sheet1!A1:B20,2,“False”)’); using this method results on the Hot showing the formula as text a…

Issue: [9.0.0] No render when data in HyperFormula is updated outside of Handsontable

[adrian.szymanski]

Hi @david

Thank you for contacting us. This is actually a correct behavior. Most of the Handsontable’s hooks also fire the render() method additionally to update the view. HyperFormula doesn’t incorporate similar solution as it is also meant to work with other libraries. So basically while using HyperFormula methods to update the data the Handsontable’s render() method also needs to be added.

[david]

Thanks Adrian,

I thought that might be the case, but was put-off by this in the docs:

Calling this method manually is not recommended. Handsontable tries to render itself by choosing the most optimal moments in its lifecycle.
~ https://handsontable.com/docs/javascript-data-grid/api/core/#render

[adrian.szymanski]

@david

I can understand that. This description could be better but in the essence it means that it is called internally when needed, so doing it twice is not recommended.