From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matt Chastagnier Subject: Re: noob question : In a table , how to update a formula when inserting a new line Date: Sat, 8 May 2010 18:06:06 +0200 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0018810438==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1OAmXe-0007Uk-RD for emacs-orgmode@gnu.org; Sat, 08 May 2010 12:06:14 -0400 Received: from [140.186.70.92] (port=59397 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OAmXd-0007TK-01 for emacs-orgmode@gnu.org; Sat, 08 May 2010 12:06:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OAmXX-0000Ia-Sd for emacs-orgmode@gnu.org; Sat, 08 May 2010 12:06:11 -0400 Received: from fg-out-1718.google.com ([72.14.220.159]:3588) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OAmXX-0000IR-Mi for emacs-orgmode@gnu.org; Sat, 08 May 2010 12:06:07 -0400 Received: by fg-out-1718.google.com with SMTP id 22so286271fge.12 for ; Sat, 08 May 2010 09:06:06 -0700 (PDT) In-Reply-To: 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: w t <1218121@gmail.com> Cc: emacs-orgmode@gnu.org --===============0018810438== Content-Type: multipart/alternative; boundary=001485f8954875599d0486175ac1 --001485f8954875599d0486175ac1 Content-Type: text/plain; charset=ISO-8859-1 That's it !!! Big thank you w t ... it was due to that blank line between table and the line "#+TBLFM" Thank you Nick Docos too for your reply :) cheers Matt On Sat, May 8, 2010 at 5:48 AM, w t <1218121@gmail.com> wrote: > On Fri, May 7, 2010 at 7:21 PM, Matt Chastagnier > wrote: > > 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. > > Before editing the table make sure there is no blank line between the > table and the line "#+TBLFM: @4$2=vsum(@I..@II)". Then use the > M-S- command. > --001485f8954875599d0486175ac1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable That's it !!! Big thank you w t ... it was due to that blank line betwe= en table and the line "#+TBLFM"
Thank you Nick Docos too for y= our reply :)

cheers

Matt

On Sat, May 8, 2010 at 5:48 AM, w t <1218121@gmail.com> wrote:
On Fri, May 7, 2010 at 7:21 PM, Matt Chastagnier <workandroll@gmail.com> wrote:
> Hi,
>
> I've just started with org-mode and have done several tutorials. B= ut I'm
> stuck with this problem for 3 hours :
>
>
> I have :
>
> | item=A0=A0=A0 | quantity |
> |---------+----------|
> | 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 |
> | desktop |=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 u= pdated. I
> would like the formula to become @5$2 instead of @4$2 automatically.
Before editing the table make sure = there is no blank line between the
table and the line "#+TBLFM: @4$2=3Dvsum(@I..@II)". Then use the<= br> M-S-<down> command.

--001485f8954875599d0486175ac1-- --===============0018810438== 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 --===============0018810438==--