Hello, I have an issue with remote function in formula : #+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