How to get calculated values in state when using formulas

Tags: #<Tag:0x00007efc620e6810>
#1

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.

#2

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.

#3

i want to get the updated values from state of table


this is the demo code

#4

@emanuele.parini

your’re looking for the getSourceData() method

37

#5