How to load formula data with nested schema?

Getting help Questions
1

Hello.

I have a problem with loading nested data that contains formula.
The cell won’t calculate, but show as a plain text.

[
  { colA: 10, colB: { formula: '=A1', value: 10 },
  { colA: 20, colB: { formula: '=A2', value: 20 }
]

https://jsfiddle.net/chalee14634/21h08z5v/
Could you please suggest me the solutions to solve with this problem?
Thank you.

2

Hey @chalee14634

Handsontable accept an array of arrays or objects. We do not fully supported more levels of data nesting.

1 Like