Evaluate formula pass in DATA

Tags: #<Tag:0x00007efc65195678>
#1

Hi,

this is my scenario:

  • handsontable 8.4.0
  • ajax loading the html and javascript for create/render multiple handsontable (it’s look like one excel file with many sheets).

The data object that I return contains integer and formulas.
Only the formulas at the end of the columns A and B is calcutating and display the values (in any sheet).
The problem is the other formulas at the end to the columns > B and at the end ot the row that display the formula and not the value.

I find your suggestion that explain to use " this.setDataAtCell " but I don’t understand why I can’t use the formula in the data object? Why work only in the first two column?

At this link https://jsfiddle.net/f2tpya39/2/ you can find my example with the problem.

Thank’s.

#2

I solved my problem with setDataAtCell and batch.

Your’s is a great product :wink:

#3

That’s a quick update @Folk

Thank you for the feedback. I’m glad that the case is solved.

#4