search

xsanisty / calx.js

jQuery Calx - a jQuery plugin for creating formula-based calculation form
http://www.xsanisty.com/project/calx2
MIT License
198 stars 72 forks source link

set zero previous row cell #52

Open StefanoServiddio opened 7 years ago

StefanoServiddio commented 7 years ago

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?

`\

\ \ \ \ \`
sadsocket commented 6 years ago

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 commented 6 years ago

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