Formulas plugin "sheetName" property throwing error in React with TypeScript

[adrianszymanski89]

Description

If we try to set the sheetName property in the formulas plugin configuration, it throws an error:

TS2322: Type '{ engine: HyperFormula; sheetName: string; }' is not assignable to type 'DetailedSettings'.   Object literal may only specify known properties, and 'sheetName' does not exist in type 'DetailedSettings'.

This issue is present only in projects using React and TypeScript.

Steps to reproduce

1. Open provided demo
2. See the error

Demo

https://codesandbox.io/s/cocky-gauss-q72gz6?file=/src/hottable.tsx

Your environment

• Handsontable version: 12.1.3
• Browser name and version: Google Chrome 106
• Operating system: macOS Monterey 12.6

[jamshaidbutt055]

Inform Forum

[sequba]

A workaround for this issue: use any to suppress type checking:

  const formulasEngineConfig: any = {
    engine: hyperformulaInstance,
    sheetName: "hello"
  };

https://codesandbox.io/s/muddy-shadow-nmzm94?file=/src/hottable.tsx:690-789

[wave-light]

This issue is still present, using:

• handsontable@13.1.0
• @handsontable/react@13.1.0
• hyperformula@2.6.0

The fix of setting type to any works, but we need a proper fix to the types here.

[Maxth47]

I facing the same problem in the version 14.0.0

[AMBudnik]

Hi @thanhlevu this issue should be fixed with the upcoming release (around 15 - 17 Jan).

I will update this thread upon release.