From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Bach Subject: Re: Row formula in orgtbl mode Date: Thu, 05 May 2011 15:00:41 +0300 Message-ID: <4dc2916c.ce04df0a.6696.44c3@mx.google.com> References: <4dc15635.1107df0a.51c0.15c4@mx.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([140.186.70.92]:58070) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QHxEe-0003sA-Jq for emacs-orgmode@gnu.org; Thu, 05 May 2011 08:00:49 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QHxEc-0006L7-K4 for emacs-orgmode@gnu.org; Thu, 05 May 2011 08:00:48 -0400 Received: from mail-fx0-f41.google.com ([209.85.161.41]:44533) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QHxEc-0006Kx-CW for emacs-orgmode@gnu.org; Thu, 05 May 2011 08:00:46 -0400 Received: by fxm18 with SMTP id 18so1834695fxm.0 for ; Thu, 05 May 2011 05:00:45 -0700 (PDT) In-Reply-To: (Michael Brand's message of "Wed, 4 May 2011 17:26:14 +0200") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Michael Brand Cc: emacs-orgmode@gnu.org Michael Brand writes: > Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at > least to this commitdiff > http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538 I am now running the 7.5 development version checked out today. I knew I would have to do this one day... > | | a | b | c | d | > | Specific cost | 1 | 9 | 2 | 3 | > | System size | 1000 | 1000 | 1000 | 1000 | > | | 1000 | 9000 | 2000 | 3000 | > | ... | ... | ... | ... | ... | > #+TBLFM: @4$2..@4$5=@-1*@-2 > > For this application I would suggest > #+TBLFM: @4$<<..@4$>=@-1*@-2 Thanks for the quick and competent answer Michael, it worked right away. MB