From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric S Fraga Subject: Re: About range references in the spreadsheet Date: Thu, 31 Jan 2013 12:39:27 +1030 Message-ID: <87txpy85ns.fsf@ucl.ac.uk> References: <20130116232437.b04189ed2c42c927f16b8d1c@gmail.com> <878v7g6vhz.fsf@bzg.ath.cx> <87obgbcxdx.fsf@ucl.ac.uk> <87ehh6iti9.fsf@urmel.duenenhof-wilhelm.de> <87vcae8vmv.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([208.118.235.92]:48141) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1U0ja6-0005Cf-CD for emacs-orgmode@gnu.org; Wed, 30 Jan 2013 21:08:52 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1U0ja4-0005ih-CD for emacs-orgmode@gnu.org; Wed, 30 Jan 2013 21:08:50 -0500 Received: from va3ehsobe004.messaging.microsoft.com ([216.32.180.14]:56313 helo=va3outboundpool.messaging.microsoft.com) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1U0ja4-0005fu-1n for emacs-orgmode@gnu.org; Wed, 30 Jan 2013 21:08:48 -0500 Received: from mail147-va3 (localhost [127.0.0.1]) by mail147-va3-R.bigfish.com (Postfix) with ESMTP id 3DE1526017B for ; Thu, 31 Jan 2013 02:08:41 +0000 (UTC) Received: from VA3EHSMHS008.bigfish.com (unknown [10.7.14.235]) by mail147-va3.bigfish.com (Postfix) with ESMTP id 2DC77C0106 for ; Thu, 31 Jan 2013 02:08:39 +0000 (UTC) In-Reply-To: <87vcae8vmv.fsf@bzg.ath.cx> (Bastien's message of "Wed, 30 Jan 2013 17:48:24 +0100") 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: emacs-orgmode@gnu.org Bastien writes: > Hi Xue, Eric and Dieter, > > dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes: > >> (I would avoid the ambiguous expression "column two" since it is a >> relative specification) alternatively >> >> The TWO REFERENCES expand to a field range from the row above the >> current row, starting with two columns to the left up to the current >> column. > > Yes... but this is a bit long. > > I finally used this: > > @@-1$-2..@@-1 @r{in the first row up, 3 fields from 2 columns on the left} Concise and correct! I'm happy with this. -- : Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D : in Emacs 24.3.50.1 and Org release_7.9.3d-898-g005917