From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: Problem with table sums Date: Tue, 23 Feb 2010 23:08:05 +0100 Message-ID: <87y6ijk3lm.fsf@mundaneum.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hello, I have such a table whose formatting is forced by someone more powerful than me (my boss): #+TBLNAME: etape1 | | =C3=89tape 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=3D@2$3*400.00;%.2f::@3$4=3D@2$4*0.08*0.40;%.2f::@4$4=3D@2$= 4*0.08;%.2f::@5$4=3D@2$4*0.20;%.2f::@6$4=3Dvsum(@-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 | | =C3=89tape 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=3D@2$3*400.00;%.2f::@4$4=3D@2$4*0.08*0.40;%.2f::@6$4=3D@2$= 4*0.08;%.2f::@8$4=3D@2$4*0.20;%.2f::@10$4=3Dvsum(@-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 --=20 S=C3=A9bastien 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