λ-wiki
::
wikicalc
+
| 1 |
help
|
pages
|
skin
|
login
|
code
www!k! v.20120610
! CE SITE NECESSITE JAVASCRIPT !
λ-wiki :: éditeur
{h4 wikicalc} {h3 1) define the worksheet} {div {@ id:code; white-space:pre; border:1px solid; padding:5px;} °° // 1) input data : var a1 = $('A1').value ; // input dans A1 var a2 = $('A2').value ; // input dans A2 var b1 = $('B1').value ; // input dans B1 var b2 = $('B2').value ; // input dans B2 // 2) define relations between cells : var a3 = eval(a1) + eval(a2); // A3 = A1 + A2 var b3 = eval(b1) * eval(b2); // B3 = B1 * B2 var c1 = a3; // C1 = A3 var c2 = b3; // C2 = B3 var c3 = c1 + c2; // C3 = C1 + C2 // 3) display results : $('A3').innerHTML = 'A1+A2 = ' + a3; $('B3').innerHTML = 'B1*B2 = ' + b3; $('C1').innerHTML = '= A3 = ' + c1; $('C2').innerHTML = '= B3 = ' + c2; $('C3').innerHTML = 'C1+C2 = ' + c3; °°} {h3 2) display} {table {@ text-align:center;} {tr {@ font-weight:bold; } {td } {td {@ width:30%;} A} {td {@ width:30%;} B} {td {@ width:30%;} C} } {tr {td 1} {td {@ background:#ccc;} {input {@ code:code; id:A1; value:0;}} } {td {@ background:#ccc;} {input {@ code/code; id:B1; value:0;}} } {td {@ id:C1;} = A3 =} } {tr {td 2} {td {@ background:#ccc;} {input {@ code:code; id:A2; value:0;}} } {td {@ background:#ccc;} {input {@ code:code; id:B2; value:0;}} } {td {@ id:C2;} = B3 =} } {tr {td 3} {td {@ id:A3;} A1+A2 =} {td {@ id:B3;} B1+B2 =} {td {@ id:C3;} C1+C2 =} } } {h6 explanations} {p Data are keyed in cells A1, A2, B1, B2 ; they must be numbers or whatever mathematical expressions returning valid numbers such as 1+2+3+4, Math.PI, Math.cos(Math.PI/4), ...} {p The results are displayed in cells A3, B3, C1, C2, C3 depending on operations defined in part 2) of the code.}