Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentesRévision précédenteProchaine révision | Révision précédenteProchaine révisionLes deux révisions suivantes | ||
logiciel:internet:dokuwiki:plugins:tablecalc:start [2021/10/23 17:00] – [III] admin | logiciel:internet:dokuwiki:plugins:tablecalc:start [2021/10/23 17:18] – [10e exemple] admin | ||
---|---|---|---|
Ligne 112: | Ligne 112: | ||
| 5 | 6 | 7 | 8 | | | 5 | 6 | 7 | 8 | | ||
| **~~=sum(r0c0: | | **~~=sum(r0c0: | ||
- | === IV === | + | === 4e exemple |
<cli prompt=' | <cli prompt=' | ||
Ligne 141: | Ligne 141: | ||
=== V === | === V === | ||
+ | |||
+ | <cli prompt=' | ||
+ | |2| | ||
+ | |3| | ||
+ | |4| | ||
+ | |5| | ||
+ | |6| | ||
+ | |7| | ||
+ | |8| | ||
+ | |9| | ||
+ | |11| | ||
+ | |~~=average(range(col(), | ||
|1| | |1| | ||
Ligne 154: | Ligne 166: | ||
|~~=average(range(col(), | |~~=average(range(col(), | ||
- | 1 | + | === 6e exemple === |
- | 2 | + | |
- | 3 | + | <cli prompt=' |
- | 4 | + | | 3 | 4 | |
- | 5 | + | |
- | 6 | + | Sum: **~~=sum(ex6_1.c0r0: |
- | 7 | + | |
- | 8 | + | |
- | 9 | + | |
- | 11 | + | |
- | 5.5 | + | |
- | VI | + | |
| ~~=label(ex6_1)~~1 | 2 | | | ~~=label(ex6_1)~~1 | 2 | | ||
Ligne 172: | Ligne 178: | ||
Sum: **~~=sum(ex6_1.c0r0: | Sum: **~~=sum(ex6_1.c0r0: | ||
- | 1 2 | + | === 7e exemple === |
- | 3 4 | + | |
- | Sum: 10 | + | <cli prompt=' |
- | VII | + | | 13 | 14 | |
+ | |||
+ | | ~~=label(ex7_2)~~1 | 2 | | ||
+ | | 3 | 4 | | ||
+ | |||
+ | Sum: **~~=sum(ex7_1.c0r0: | ||
| **~~=label(ex7_1)~~11** | ~~=sum(ex7_2.c0r0: | | **~~=label(ex7_1)~~11** | ~~=sum(ex7_2.c0r0: | ||
Ligne 186: | Ligne 196: | ||
Sum: **~~=sum(ex7_1.c0r0: | Sum: **~~=sum(ex7_1.c0r0: | ||
- | 11 10 | + | === 8e exemple === |
- | 13 14 | + | |
- | 1 2 | + | |
- | 3 4 | + | |
- | Sum: 48 | + | <cli prompt=' |
- | VIII | + | | 1 | 7 | |
+ | | 2 | 8 | | ||
+ | | 3 | 9 |</ | ||
| **~~=min(c0r1: | | **~~=min(c0r1: | ||
Ligne 199: | Ligne 208: | ||
| 3 | 9 | | | 3 | 9 | | ||
- | 1 9 | + | === 9e exemple === |
- | 1 7 | + | |
- | 2 8 | + | <cli prompt=' |
- | 3 9 | + | | 0 | ~~=check(cell(0, |
- | IX | + | | x | ~~=check(cell(0, |
+ | | | ~~=check(cell(0, | ||
+ | | **** | ~~=check(cell(0, | ||
| 1 | ~~=check(cell(0, | | 1 | ~~=check(cell(0, | ||
Ligne 211: | Ligne 222: | ||
| **** | ~~=check(cell(0, | | **** | ~~=check(cell(0, | ||
- | 1 True | + | === 10e exemple === |
- | 0 False | + | |
- | x False | + | <cli prompt=' |
- | False | + | | 3 | 3 | 3=3 | ~~=check(compare(cell(0, |
- | False | + | | 4 | 5 | 4<5 | ~~=check(compare(cell(0, |
- | X | + | | 6 | 7 | 6>7 | ~~=check(compare(cell(0, |
+ | | 8 | 9 | 8>9 | ~~=check(compare(cell(0, | ||
+ | | 10 | 10 | 10≥10 | ~~=check(compare(cell(0, | ||
+ | | 11 | 11 | 11≤11 | ~~=check(compare(cell(0, | ||
+ | | 12 | 12 | 12≠12 | ~~=check(compare(cell(0, | ||
| 1 | 2 | 1=2 | ~~=check(compare(cell(0, | | 1 | 2 | 1=2 | ~~=check(compare(cell(0, | ||
Ligne 227: | Ligne 242: | ||
| 12 | 12 | 12≠12 | ~~=check(compare(cell(0, | | 12 | 12 | 12≠12 | ~~=check(compare(cell(0, | ||
- | 1 2 1=2 False | + | === 11e exemple === |
- | 3 3 3=3 True | + | |
- | 4 5 4<5 True | + | |
- | 6 7 6>7 False | + | |
- | 8 9 8>9 False | + | |
- | 10 10 10≥10 True | + | |
- | 11 11 11≤11 True | + | |
- | 12 12 12≠12 False | + | |
- | XI | + | |
Operator Equation Result | Operator Equation Result | ||
+ ~~= 3 + 2 ~~ 5 | + ~~= 3 + 2 ~~ 5 |