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