[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Problem with table sums
From: |
Sébastien Vauban |
Subject: |
[Orgmode] Problem with table sums |
Date: |
Tue, 23 Feb 2010 23:08:05 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/23.1.50 (gnu/linux) |
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:
@address@hidden;%.2f::@address@hidden;%.2f::@address@hidden;%.2f::@address@hidden;%.2f::@6$4=vsum(@address@hidden);%.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:
@address@hidden;%.2f::@address@hidden;%.2f::@address@hidden;%.2f::@address@hidden;%.2f::@10$4=vsum(@address@hidden);%.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)?
Best regards,
Seb
--
Sébastien Vauban
- [Orgmode] Problem with table sums,
Sébastien Vauban <=