Need help to update cell in a column value when other cells in the Row get updated

Tags: #<Tag:0x00007efc729465e0>
#1

Hi there,

I am trying to use HandsonTable in React.js. I have a usecase where I should develop a simple table which looks like this:

A B Sum
2 5 7
3 8 11

Basically the idea is to get the sum of values in A and B column in the same row in Sum column. The table must react to any changes in the values of A and B and automatically display Sum whenever there is any change in A and B. I am new to HandsonTable so I am struggling to implement this in React.js.

Any help would be greatly appreciated

#2

https://handsontable.com/docs/react-hot-column/
You can reference the link.

#3

Hi anguof,

Thanks for the reply. Can you please help me with a sample code in React.js? I have referred the link that you have mentioned but am still unable to implement it.

#4

Hi @d4moworkshop123 sorry for the late response.

Here is the demo with a solution that you need: https://jsfiddle.net/aszymanski/7bdavhqk/2/

In order to make calculations you need to use Formulas plugin with HyperFormula engine. It will automatically update the result whenever you change the values in the cells that are declared as a part of the calculation.

I hope that helps.

#5

Hi adrian,

Thank you very much for the response and the code and it is exactly what I needed. You just made my day!

Hope you have a good day too!

#6