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...@2$3*400.00;%.2f::@3...@2$4*0.08*0.40;%.
2f::@4...@2$4*0.08;%.2f::@5...@2$4*0.20;%.2f::@6$4=vsum(@-...@-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...@2$3*400.00;%.2f::@4...@2$4*0.08*0.40;%.
2f::@6...@2$4*0.08;%.2f::@8...@2$4*0.20;%.2f::@10$4=vsum(@-...@-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
_______________________________________________
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
