How to calculate formula inside handsontable

Getting help Questions
,
1

Im using handsontable with angular and hyperformula, is there any chance to paste calculated formula directly in handsontable sourceData, after finish editing cell with formula?

2

Hi @nikoches

Thank you for contacting us. All of the calculations are done at the initialization of the table, so in this case I set them back to the source data with the logic provided below:

for (let i = 0; i < hot.countRows(); i++) {
  hot.setSourceDataAtCell(i, 0, hot.getDataAtRow(i)[0])
}

And here’s an example: https://jsfiddle.net/handsoncode/povu0bst/

The example is created in Vanilla, but the logic would like basically the same for Angular where hot is a Handsontable instance.

3

Hi @nikoches

Can you give me an update here? Did my solution help you with the problem?

4

Hello! im very sorry, but for now i can’t give you feedback about your answer, becausee some other important stuff to do, but i will check this out as fast as i can, about 2-3 weeks.Thank you for quick answer!

5

Hi @nikoches

Don’t worry! Let me know once you have time.

6

Hello! thanks for you help, its works!

7

Hi @nikoches

Thank you for the update. I’m glad that it helped. I will close this topic now. If you would need help with anything else, feel free to open a new one.