From mboxrd@z Thu Jan 1 00:00:00 1970 From: Benjamin Andresen Subject: Re: Question on spreadsheet formula Date: Sat, 26 Sep 2009 05:14:55 +0200 Message-ID: <87zl8ie6s0.fsf@in-ulm.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MrNky-0003Jk-LL for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:15:32 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MrNkt-0003JY-HJ for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:15:31 -0400 Received: from [199.232.76.173] (port=53639 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MrNkt-0003JV-Ap for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:15:27 -0400 Received: from mail.in-ulm.de ([217.10.8.10]:42835) by monty-python.gnu.org with smtp (Exim 4.60) (envelope-from ) id 1MrNks-0001ct-Nn for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:15:27 -0400 In-Reply-To: (RC's message of "Sat, 26 Sep 2009 03:08:11 +0000 (UTC)") 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 Hey RC, If you set the value of D2 to 0 what you want will be achieved. The table would look like this: |-----+------+------+-------| | No. | P | E | B | |-----+------+------+-------| | | | | 0 | | 1 | 5000 | 2000 | 3000 | | 2 | 7000 | 1000 | 9000 | | 3 | 5000 | 1000 | 13000 | #+TBLFM: $4=@-1$4+$2-$3::@2$4=0 ^^^^ That's the interesting part > Is there a way I can restrict application of the column formula to below the > horizontal line. No idea. > Thanks, > RC br, benny