How to get calculated values in state when using formulas

hello,
i have successfully implemented the formula in demo but here is thing i am using redux to store data of table since i want to use it somewhere else for calculations but i realize that when i use formula like “=TRUNC(C1*(1+D14/100),2)” while providing initial data ,i can see the required value but when i try to get it from state i get this “=TRUNC(C1*(1+D14/100),2)” formula instead of value.

Hi @edmrepost33

If we could look at the code it would be simpler.

So, please use this demo https://jsfiddle.net/u7t8cLn3/
and change it to suit your application.

i want to get the updated values from state of table
https://codesandbox.io/s/charming-shape-o7jqg?fontsize=14&hidenavigation=1&theme=dark
this is the demo code

@emanuele.parini

your’re looking for the getSourceData() method