From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: table formula w/o calc Date: Sun, 17 Dec 2006 12:10:28 +0100 Message-ID: References: <864prwfp6o.fsf@presario.homeunix.org> Mime-Version: 1.0 (Apple Message framework v624) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Gvtue-0000hM-3D for emacs-orgmode@gnu.org; Sun, 17 Dec 2006 06:10:36 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Gvtub-0000gG-Pf for emacs-orgmode@gnu.org; Sun, 17 Dec 2006 06:10:34 -0500 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GvtuY-0000fi-40 for emacs-orgmode@gnu.org; Sun, 17 Dec 2006 06:10:32 -0500 Received: from [64.233.182.187] (helo=nf-out-0910.google.com) by monty-python.gnu.org with esmtp (Exim 4.52) id 1GvtuX-00059U-8U for emacs-orgmode@gnu.org; Sun, 17 Dec 2006 06:10:29 -0500 Received: by nf-out-0910.google.com with SMTP id d4so1662559nfe for ; Sun, 17 Dec 2006 03:10:28 -0800 (PST) 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: Eddward DeVilla Cc: emacs-orgmode@gnu.org On Dec 16, 2006, at 6:14, Eddward DeVilla wrote: > On 12/15/06, Xiao-Yong Jin wrote: >> "Eddward DeVilla" writes: >> Maybe you've already tried this. But I guess it's still worth >> mentioning. You probably need a `#' in the first row as following >> >> |---+------+----+----+----+----------------| >> | | name | P1 | P2 | P3 | TOT | >> |---+------+----+----+----+----------------| >> | # | Al | 10 | 9 | 8 | ='(+ $3 $4 $5) | >> | # | Bob | 9 | 8 | 10 | | >> | # | Carl | 8 | 10 | 9 | | >> | # | Dan | 10 | 10 | 10 | | >> |---+------+----+----+----+----------------| > > Not sure if I've done this variation before. Just tried now without > luck. Thanks for the suggestion though. You don't necessarily need these markers in the first column. To evaluate the equation, simply put the cursor into the field where you have typed the equation, and press either TAB or RET. This will store the equation in a #TBLFM line below the table and replace it in the table with the result of this calculation. To get it applied to all line in the table, press `C-u C-c *', or, alternatively, `C-u C-c C-c'. This is in the manual, section 3.3 to be precise. But obviously not explained clearly enough. Please, if you find time, read that part and tell me what should have been there or anywhere else, so that you would not have gotten stuck. The # markers in the first line mean that each time you press TAB, all equations in that line will be re-applied. This can be useful if you have lots of equations, but it can slow down editing. - Carsten -- Carsten Dominik Sterrenkundig Instituut "Anton Pannekoek" Universiteit van Amsterdam Kruislaan 403 NL-1098SJ Amsterdam phone: +31 20 525 7477