Hello, flav <flav.justf...@gmail.com> writes:
> Hello, I have an issue with remote function in formula : > > #+TBLNAME: ch-mdp-aot-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-aot-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-aot-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 This should be fixed. Thank you for reporting it. Regards, -- Nicolas Goaziou