Re: Problem with table sums

[Carsten Dominik <carsten.dominik@gmail.com>]

On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:

> Hello,
>
> I have such a table whose formatting is forced by someone more  
> powerful than
> me (my boss):
>
>   #+TBLNAME: etape1
>   |   | Étape 1           | p.j | EUR HTVA |
>   |---+-------------------+-----+----------|
>   |   | Prestations       | 100 | 40000.00 |
>   |   | Frais annexes     |     |  1280.00 |
>   |   | Gestion du projet |     |  3200.00 |
>   |   | Licence           |     |  8000.00 |
>   |---+-------------------+-----+----------|
>   |   | Total             |     | 52480.00 |
>   | ^ |                   |     |    Total |
>   #+TBLFM: @2$4=@2$3*400.00;%.2f::@3$4=@2$4*0.08*0.40;%. 
> 2f::@4$4=@2$4*0.08;%.2f::@5$4=@2$4*0.20;%.2f::@6$4=vsum(@-I..@-II);%. 
> 2f
>
> It works as expected.
>
> Though, I need to re-use some of the intermediate computations for  
> another
> "summary table". Therefore, I add names to some cells:
>
>   #+TBLNAME: etape1
>   |   | Étape 1           | p.j | EUR HTVA        |
>   |---+-------------------+-----+-----------------|
>   |   | Prestations       | 100 | 40000.00        |
>   | ^ |                   | pj  | Prestations     |
>   |   | Frais annexes     |     | 1280.00         |
>   | ^ |                   |     | FraisAnnexes    |
>   |   | Gestion du projet |     | 3200.00         |
>   | ^ |                   |     | GestionDuProjet |
>   |   | Licence           |     | 8000.00         |
>   | ^ |                   |     | Licence         |
>   |---+-------------------+-----+-----------------|
>   |   | Total             |     | 40000.00        |
>   | ^ |                   |     | Total           |
>   #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%. 
> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II); 
> %.2f
>
> Now, the total is wrong: it's the value of the first cell... Like if  
> the `^'
> prefix was simply dropped... and total limited to the first real  
> figure.
>
> Any reason for this phenomenon?  Or workaround (other than  
> describing every
> cell to be summed)?

Well, the reason is that the parser probably stops at the first text  
when summing, it tries to add "Prestations".

I am afraid there is not good work-around for this.

- Carsten

>
> Best regards,
>  Seb
>
> -- 
> Sébastien Vauban
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten