emacs-orgmode
[Top][All Lists]
Advanced

[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





reply via email to

[Prev in Thread] Current Thread [Next in Thread]