jQuery Calx is now reached version 2.2.5 and bring several bug fix and improvement since 2.2.0, and here is list of changes that has been made on jQuery Calx
- Fix registerVariable
- Fix calx refresh
- Fix bug on SUMPRODUCT formula function
- Fix bug on VLOOKUP formula function
- Fix incompatibility with IE
- Add feature to register cell without creating html element to be bound with the cell object
You can now strip-out hidden element on your html file that act as proxy cell, and create cell directly by passing cell info into data section in the calx configuration.
<form id="calx">
<input data-cell="B1">
</form>
<script>
$('#calx').calx({
data : {
'A1' : { value: 100 },
'A2' : { value: 200 },
'A3' : { value: 150 },
'A4' : { value: 50 },
'B1' : { formula: 'SUM(A1:A4)' },
}
});
</script>When initializing calx as shown above, the cell B1 will receive ‘500’ as the result of the calculation.
That’s all, and as always, any feedback from you is much appreciated!
Hi,
I have started using this JS library and it works perfectly for most cases, but nested IF conditions don’t seem to work. I read your comment about spaces with comparison operator, and have added spaces for two nested IF conditions, which works, but more than 2 don’t seem to work, what am I missing here?
This works
IF(A6 = 1,"Likely",IF(A3 > 2,"Unlikely","Somewhat Likely"))
This doesn’t work
IF(B9 = "Unknown", 0, IF(A8 = "No", 1, (IF(AND(A8 "No", B9=""), 0, 1))))
Would appreciate your reply, as this is a decision I have to make with using this library for allowing authors to define formulae (they would be familiar with excel, so I have no control on how many IF levels they will use), and other users to fill data and I through my code will compute the scoring, as if it was an excel sheet.
Your library is one of the best I have used and so would (unfortunately) need to change to another library, if these problems don’t have a working fix. Also only your library has the ability to use data-cell and data-formula, making it so easy to develop against.
HI Elvis,
Multiple nested if should works, but it seems your formula has a typo around
AND(A8 "No", B9="")which shouldAND(A8 = "No", B9="")Regards,
Ikhsan
Fungsi ISBLANK, ISNUMBER belum ada ya Mas, ditambahi dong, ini penting banget loh. Matur nuwun
Apakah ini juga bug.. fungsi PRODUCT apakah memang tidak berfungsi? Di saya misal saya pakai formula PRODUCT(A1:A5) dimana
A1: ‘5’
A2: ”
A3: ‘4’
A4:”
A5:’3′
Permisi mas, datang dengan pertanyaan lagi nih, mohon dibantu 🙂 saya pingin buat data dengan value yang berubah berdasarkan input type range seperti berikut ini. Mohon saran, mantur nuwun.
<form id="grafik"> <div align="center"> <table class="tabel"><tbody> <tr> </tr> <tr><td data-cell="A1">pH</td><td data-cell="B1"><input value="" type="range" min="0" max="14" step="1" /></td></tr> <tr><td data-cell="A2">pOH</td><td data-cell="B2"></td></tr> </tbody> </table> </div> <div align="center"> Grafiknya di bawah ini</div> <div align="center"> <div data-formula="GRAPH(A1:B2, ['type=bar', 'label=A1:B2', 'legend=0'])" style="height: 250px; width: 400px;"> </div> </div> </form> <script> $ ('#grafi').calx({ data : { B2 : {formula : '14-B1' }, } }); </script>Wis kucoba ning tetap error ini Mas,
<div> <form id="small"> <table class="tabel"><tbody> <tr><th>Data</th></tr> <tr><td><input data-cell="A2" /></td></tr> <tr><td><input data-cell="A3" /></td></tr> <tr><td><input data-cell="A4" /></td></tr> <tr><td><input data-cell="A5" /></td></tr> <tr><td><input data-cell="A6" /></td></tr> <tr><td><input data-cell="A7" /></td></tr> <tr><td><input data-cell="A8" /></td></tr> <tr><td><input data-cell="A9" /></td></tr> </tbody> </table> </form></div> <script> $ ('#small').calx({ data : { A2 : { value : '123' }, A3 : { value : '23' }, A4 : { value : '34' }, A5 : { value : '5' }, A6 : { value : '0' }, A7 : { value : '777' }, A8 : { formula : 'MAX(A2:A7)' }, A9 : { formula : 'SMALL(A2:A7,COUNTIF(A2:A7,0)+1)' }, } }); </script>Mohon pencerahannya, Oh ya saya masih pakai calx 2.2.0
wah, kayanya ada bug di countif sama small sama countif mas
ntar tak coba fix n rilis patch nya
Sipppp ditunggu perbaikannya njih Mas.
Hali Mas Xsan yg ganteng 🙂
Saya coba pakai rumus SMALL(G2:G17;COUNTIF(G2:G17;0)+1) untuk menentukan nilai terkecil dari suatu data namun tidak termasuk data yang bernilai nol, hasilnya selalu #error, Kalau di excel biasa hasilnya ok-loh. Mohon pencerahannya, maturnuwun.
pkae koma mas, bukan titik koma 😀
Ok matur nuwun (Y)