#+TBLNAME: ch-mdp-août-2013
|---+------+--------+-------+-------+----------+-------+----------+--------+----------+--------|
| | 2013 | août | Lundi | Mardi | Mercredi | Jeudi | Vendredi | Samedi | Dimanche | |
|---+------+--------+-------+-------+----------+-------+----------+--------+----------+--------|
| | sem | jour | 19 | 20 | 21 | 22 | 23 | 24 | 25 | Stotal |
| # | s33 | charge | | | 1 | 1 | 1 | | | 3 |
|---+------+--------+-------+-------+----------+-------+----------+--------+----------+--------|
| | sem | jour | 26 | 27 | 28 | 29 | 30 | 31 | | |
| # | s34 | charge | | 1 | | | | | | 1 |
|---+------+--------+-------+-------+----------+-------+----------+--------+----------+--------|
| # | Mois | | | | | | | | | 4 |
|---+------+--------+-------+-------+----------+-------+----------+--------+----------+--------|
#+TBLFM: $11=vsum($4..$>>)::@>$11=vsum(@<..@>>);N
***** ch-mdp-total-2013
#+TBLNAME: ch-mdp-total
|-------+--------|
| mois | charge |
|-------+--------|
| août | 3 |
|-------+--------|
| total | 3 |
|-------+--------|
#+TBLFM: @2$2=remote(ch-mdp-août-2013, @>$>)::@>$2=vsum(@<<..@>>)
give me :
when I update :
#+TBLNAME: ch-mdp-total
|-------+--------|
| mois | charge |
|-------+--------|
| août | #ERROR |
|-------+--------|
| total | #ERROR |
|-------+--------|
#+TBLFM: @2$2=remote(ch-mdp-août-2013, @>$>)::@>$2=vsum(@<<..@>>)
debug formula :
Substitution history of formula
Orig: remote(ch-mdp-août-2013, @>$>)
$xyz-> remote(ch-mdp-août-2013, @>$>)
@r$c-> remote(ch-mdp-août-2013, @>$>)
$1-> remote(ch-mdp-août-2013, @>$>)
----------------^
Error: Expected `)'
Orig: vsum(@2..@2)
$xyz-> vsum(@2..@2)
@r$c-> vsum((#ERROR))
$1-> vsum((#ERROR))
------^
Error: #'s not allowed in this context
Thanks for help
--
flav