From mboxrd@z Thu Jan 1 00:00:00 1970 From: Giovanni Ridolfi Subject: Re: table: actualise columns with formulas. (C-num C-c=) Date: Mon, 14 Jun 2010 14:33:15 +0200 Message-ID: <83wru1iyk4.fsf@yahoo.it> 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=34935 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OO8qr-0000m5-JN for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 08:33:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OO8qp-0001ui-P5 for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 08:33:17 -0400 Received: from slim-4c.inet.it ([213.92.5.127]:62953) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OO8qp-0001uQ-FN for emacs-orgmode@gnu.org; Mon, 14 Jun 2010 08:33:15 -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 | > Now the only thing I have to do is copy and paste it into > the rows below that formula in the same column. why don't you use: | Res1| Res2| Total | 3 | 4 | =$1+$2 | 4 | 5 | #+TBLFM:$3=$1+S2 ? then with C-c in the "#+TBLFM:$3" line your table will be updated I think also if you press TAB with the cursor in the third column. cheers Giovanni