Accents Issues in Table formula in French.

Accents Issues in Table formula in French.

[flav]

[-- Attachment #1: Type: text/plain, Size: 2254 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 4502 bytes --]

Re: Accents Issues in Table formula in French.

[Nicolas Goaziou]

Hello,

flav <flav.justflav@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