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)?