Updating Hyperformula sheet

Hi,
I refer to my previous topic: Predefined formulas and filtering - #26

After sorting my data outside of HT and loading it back in using loadData() I see that HyperFormula is still using the old data. I tried using setSheetContent() but it does’nt seem to work on my table. what am I doing wrong?

this.hotInstance.loadData(newData, 'loadData')

                        const engine = this.hotInstance.getPlugin('formulas').engine

                        const changes = engine.setSheetContent(0, newData);

type or paste code here

type or paste code here

Hi @vanjoe

Just to confirm, the data in Handsontable instance are correctly updated and only the HyperFormula instance doesn’t seem to get the same updated data?

Hi, thanks for the reply. Its resolved now, my mistake.
On another issue to sort using custom code I have disabled columnSorting on the table. What would be a good technique to add the sort icons on the column being custom sorted?

Hi @vanjoe

Thank you for the update. For inserting a custom HTML elements into the column headers, you can use this hook: Hooks API reference - JavaScript Data Grid | Handsontable