From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matt Chastagnier Subject: noob question : In a table , how to update a formula when inserting a new line Date: Sat, 8 May 2010 04:21:34 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1868766374==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1OAZfg-0005XN-7r for emacs-orgmode@gnu.org; Fri, 07 May 2010 22:21:40 -0400 Received: from [140.186.70.92] (port=58126 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OAZfe-0005Uj-4X for emacs-orgmode@gnu.org; Fri, 07 May 2010 22:21:39 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OAZfc-0007YB-EL for emacs-orgmode@gnu.org; Fri, 07 May 2010 22:21:38 -0400 Received: from fg-out-1718.google.com ([72.14.220.154]:53567) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OAZfc-0007Xy-9t for emacs-orgmode@gnu.org; Fri, 07 May 2010 22:21:36 -0400 Received: by fg-out-1718.google.com with SMTP id e12so1368302fga.12 for ; Fri, 07 May 2010 19:21:34 -0700 (PDT) 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: emacs-orgmode@gnu.org --===============1868766374== Content-Type: multipart/alternative; boundary=0016364570ecac3a3404860bd5dd --0016364570ecac3a3404860bd5dd Content-Type: text/plain; charset=ISO-8859-1 Hi, I've just started with org-mode and have done several tutorials. But I'm stuck with this problem for 3 hours : I have : | item | quantity | |---------+----------| | laptop | 4 | | desktop | 7 | |---------+----------| | Total | 11 | #+TBLFM: @4$2=vsum(@I..@II) I insert a new line [because I will want to add a new item] (M-S down) and update the table (C-u C-c C-c) : | item | quantity | |---------+----------| | laptop | 4 | | desktop | 7 | | | 11 | |---------+----------| | Total | 11 | #+TBLFM: @4$2=vsum(@I..@II) but my formula isn't updated automatically so the wrong field is updated. I would like the formula to become @5$2 instead of @4$2 automatically. I've searched during 2 hours with google but found nothing :/ ... Is it possible to do it? Cause It's very annoying to update the formula "by hand" (sorry for my english). and just a big thank you for this very powerful extension of emacs ^^. Thank you in advance for having read, hoping for an answer if you have a bit time, Salutation Matt C --0016364570ecac3a3404860bd5dd Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

I've just started with org-mode and have done several = tutorials. But I'm stuck with this problem for 3 hours :


I have :

| item=A0=A0=A0 | quantity |
|---------+----------|<= br>| laptop=A0 |=A0=A0=A0=A0=A0=A0=A0 4 |
| desktop |=A0=A0=A0=A0=A0=A0= =A0 7 |
|---------+----------|
| Total=A0=A0 |=A0=A0=A0=A0=A0=A0 11 |=

#+TBLFM: @4$2=3Dvsum(@I= ..@II)

I insert a new line [because I will want to add a new item] (M-S down) = and update the table (C-u C-c C-c) :

| item=A0=A0=A0 | quantity ||---------+----------|
| laptop=A0 |=A0=A0=A0=A0=A0=A0=A0 4 |
| desk= top |=A0=A0=A0=A0=A0=A0=A0 7 |
|=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0 11 |
|---------+----------= |
| Total=A0=A0 |=A0=A0=A0=A0=A0=A0 11 |

#+TBLFM: @4$2=3Dvsum(@I.= .@II)

but my formula isn= 't updated automatically so= the wrong field is updated. I = would like the formula to become

and just a big thank you for this very powerful extension of emacs ^^.<= br>
Thank you in= advance for having read,
hoping for an answer if you have a bit time,

Salutation

Matt = C





--0016364570ecac3a3404860bd5dd-- --===============1868766374== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============1868766374==--