set zero previous row cell

[StefanoServiddio]

Hi,

I'm using dynamic forms with three rows. When I set a value in a row, a cell of previous row sets its value to zero.
Can you help me, please?

<td><input class="form-control input-sm text-right" data-cell="A'+i+'" data-format="0"></td>\ <td><input class="form-control input-sm" data-cell="B'+i+'"></td>\ <td><input class="form-control input-sm text-right" data-cell="C'+i+'" data-format="$ 0,0.00"></td>\ <td><input class="form-control input-sm text-right" data-cell="D'+i+'" data-format="0[.]00"></td>\ <td><input class="form-control input-sm text-right" data-cell="E'+i+'" data-format="0,0[.]00 %"></td>\ <td><input class="form-control input-sm text-right" data-cell="F'+i+'" data-format="$ 0,0.00" data-formula="D'+i+'*(C'+i+'-(C'+i+'*E'+i+'))"></td>\

[sadsocket]

Did you ever find a solution for this? I've played with the data-format a bit and as far as I can tell Calx is truncating the number whenever it finds a non numeric character.

So an input that says $1,000,000 gets truncated to 0 on update/calculate.
And input that says 100,000 gets truncated to 100 on update/calculate.

[digitalredefned]

Having the same issue. My interim fix was to create hidden form fields that had the value without cell formatting. Used jquery keypress to update the hidden fields