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

Reply via email to