Updating Hyperformula sheet

Getting help Questions
,
1

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
2

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?

3

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?

4

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