From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Problem with table sums Date: Wed, 24 Feb 2010 10:40:01 +0100 Message-ID: <13C985E1-535E-42D0-9004-12E0618DEADA@gmail.com> References: <87y6ijk3lm.fsf@mundaneum.com> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NkDj1-0003vp-0x for emacs-orgmode@gnu.org; Wed, 24 Feb 2010 04:40:11 -0500 Received: from [140.186.70.92] (port=47019 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NkDiw-0003sc-1r for emacs-orgmode@gnu.org; Wed, 24 Feb 2010 04:40:10 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NkDiv-0003uO-05 for emacs-orgmode@gnu.org; Wed, 24 Feb 2010 04:40:06 -0500 Received: from mail-ew0-f212.google.com ([209.85.219.212]:64428) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NkDiu-0003uF-S2 for emacs-orgmode@gnu.org; Wed, 24 Feb 2010 04:40:04 -0500 Received: by ewy4 with SMTP id 4so698722ewy.8 for ; Wed, 24 Feb 2010 01:40:03 -0800 (PST) In-Reply-To: <87y6ijk3lm.fsf@mundaneum.com> 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@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: =?ISO-8859-1?Q?S=E9bastien_Vauban?= Cc: emacs-orgmode@gnu.org On Feb 23, 2010, at 11:08 PM, S=E9bastien Vauban wrote: > Hello, > > I have such a table whose formatting is forced by someone more =20 > powerful than > me (my boss): > > #+TBLNAME: etape1 > | | =C9tape 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;%.=20 > 2f::@4$4=3D@2$4*0.08;%.2f::@5$4=3D@2$4*0.20;%.2f::@6$4=3Dvsum(@-I..@-II)= ;%.=20 > 2f > > It works as expected. > > Though, I need to re-use some of the intermediate computations for =20 > another > "summary table". Therefore, I add names to some cells: > > #+TBLNAME: etape1 > | | =C9tape 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;%.=20 > 2f::@6$4=3D@2$4*0.08;%.2f::@8$4=3D@2$4*0.20;%.2f::@10$4=3Dvsum(@-I..@-II= );=20 > %.2f > > Now, the total is wrong: it's the value of the first cell... Like if =20= > the `^' > prefix was simply dropped... and total limited to the first real =20 > figure. > > Any reason for this phenomenon? Or workaround (other than =20 > describing every > cell to be summed)? Well, the reason is that the parser probably stops at the first text =20 when summing, it tries to add "Prestations". I am afraid there is not good work-around for this. - Carsten > > Best regards, > Seb > > --=20 > S=E9bastien 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 - Carsten