Error involving sheetId when upgrading to Hyperformula

Tags: #<Tag:0x00007f8b285ef938>
#1

I thought I’d experiment with upgrading to the new Hyperformula. I upgraded to:

"handsontable": "^9.0.2",
"@handsontable/react": "^9.0.2",
"hyperformula": "^1.0.0",

I have this simple spreadsheet

return <div>
  <HotTable
    licenseKey='non-commercial-and-evaluation'
    data={[[1,2],[3,4]]}
    formulas={{
      engine: HyperFormula,
    }}
  /></div>

and I get this error:

Uncaught Error: Expected value of type: number for config parameter: sheetId

I understand that the new version of Hyperformula uses sheetId now, but I’m not sure where to add sheetId. (Adding it to the formulas object didn’t help.)

Interestingly, the error goes away if I remove the data line.

Am I missing a place to put in a sheetId or is this a bug?

Thanks!

#2

Hi @nykamp

Handsontable is not yet prepared to work with HyperFormula@1.0.0. It is still using v 0.6.0.
I do not have any updates about upgrading the version of HyperFormula within the Handsontable plugin. But you can track our Projects tab https://github.com/handsontable/handsontable/projects to stay up-to-date with the integration.

#3

Hi @nykamp

Just an hour ago we published Handsontablr v10 with HyperFormula v1.2.0

#4