From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bernt Hansen Subject: Re: table: actualise columns with formulas. (C-num C-c=) Date: Mon, 14 Jun 2010 12:12:34 -0400 Message-ID: <87d3vt385p.fsf@gollum.intra.norang.ca> References: <878w6h7u7k.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from [140.186.70.92] (port=40733 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OOCHK-0002Lc-B1 for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 12:12:51 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OOCHI-0000Vc-T1 for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 12:12:50 -0400 Received: from mho-02-ewr.mailhop.org ([204.13.248.72]:50502) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OOCHI-0000U9-QS for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 12:12:48 -0400 In-Reply-To: <878w6h7u7k.fsf@mat.ucm.es> (Uwe Brauer's message of "Mon\, 14 Jun 2010 13\:02\:39 +0200") 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: Uwe Brauer Cc: emacs-orgmode@gnu.org Uwe Brauer writes: > Hello > > Programs like OO calc allow me to actualise automatically > all rows of a column containing a formula. > > Like: > > Res1| Res2| Total > 3 | 4 | =$1+$2 > 4 | 5 | > 4 | 5 | > 4 | 6 | > 4 | 7 | > 4 | 8 | > 4 | 9 | If you prefix the first column of the table so that it is a valid org-mode table like this: |Res1| Res2| Total |3 | 4 | =$1+$2 |4 | 5 | |4 | 5 | |4 | 6 | |4 | 7 | |4 | 8 | |4 | 9 | Then you can just hit C-u C-u C-c C-c on the formula line and it moves to the bottom and updates the entire table giving you this: | Res1 | Res2 | Res1 + Res2 | | 3 | 4 | 7 | | 4 | 5 | 9 | | 4 | 5 | 9 | | 4 | 6 | 10 | | 4 | 7 | 11 | | 4 | 8 | 12 | | 4 | 9 | 13 | #+TBLFM: $3=$1+$2 HTH, Bernt > > Now the only thing I have to do is copy and paste it into > the rows below that formula in the same column. > -------------------------- > The closest thing I know in org mode is to use > C-6 C-c = > but of course I have to count the numbers of rows in > advance, so the question is: > > Could C-c = also act on a marked column, so that I don't > have to specify the numbers of rows? > > thanks > > Uwe Brauer > > > _______________________________________________ > 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