emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Problem with table sums
@ 2010-02-23 22:08 Sébastien Vauban
  2010-02-24  9:40 ` Carsten Dominik
  0 siblings, 1 reply; 6+ messages in thread
From: Sébastien Vauban @ 2010-02-23 22:08 UTC (permalink / raw)
  To: emacs-orgmode-mXXj517/zsQ

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

Best regards,
  Seb

-- 
Sébastien Vauban



_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2010-03-01  8:18 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-02-23 22:08 Problem with table sums Sébastien Vauban
2010-02-24  9:40 ` Carsten Dominik
2010-02-24 15:40   ` Dan Davison
2010-02-25 11:11     ` Carsten Dominik
2010-03-01  0:37       ` Dan Davison
2010-03-01  7:49         ` Carsten Dominik

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).