xsanisty/calx.js

Multiple dependent Formula Cell

Closed this issue · 1 comments

Hi is it possible to add a data-formula which depends on another data-formula ?
for example i have a snippet given in the same order.

 <td><input id="C0" data-format="0[.]00000" class="C0" data-formula="$A0*(2^($B0/53))" value="$A0*(2^($B0/53))" type="text"></td>
       <td><input id="D0" data-formula="1200*$C0/$C1" value="1200*$C0/$C1" type="text"></td>

 <td><input id="C1" data-format="0[.]00000" class="C1" data-formula="$A1*(2^($B1/53))" value="$A1*(2^($B1/53))" type="text"></td>
       <td><input id="D1" data-formula="1200*$C1/$C2" value="1200*$C1/$C2" type="text"></td>

Hi @mesutgungor

I am a bit unclear about your question, but this is how it works

<input id="A1" value="100">
<input id="B1" data-formula="$A1*2"> <!-- this will be 200 -->
<input id="C1" data-formula="$B1+100"> <!-- this will be 300 -->
<input id="D1" data-formula="$C1+$B1"> <!-- this will be 500 -->

a cell with formula will search the dependence and calculate the dependence first before calculating itself