From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric S Fraga Subject: Re: About range references in the spreadsheet Date: Sun, 27 Jan 2013 10:25:38 +1030 Message-ID: <87obgbcxdx.fsf@ucl.ac.uk> References: <20130116232437.b04189ed2c42c927f16b8d1c@gmail.com> <878v7g6vhz.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([208.118.235.92]:53932) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1TzFbL-0002Am-4X for emacs-orgmode@gnu.org; Sat, 26 Jan 2013 18:56:00 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1TzFbF-0005k8-9I for emacs-orgmode@gnu.org; Sat, 26 Jan 2013 18:55:59 -0500 Received: from co9ehsobe001.messaging.microsoft.com ([207.46.163.24]:53662 helo=co9outboundpool.messaging.microsoft.com) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1TzFbF-0005k2-0f for emacs-orgmode@gnu.org; Sat, 26 Jan 2013 18:55:53 -0500 In-Reply-To: <878v7g6vhz.fsf@bzg.ath.cx> (Bastien's message of "Sat, 26 Jan 2013 12:20:40 +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: Bastien Cc: Xue Fuqiao , emacs-orgmode@gnu.org Bastien writes: > Hi Xue, > > Xue Fuqiao writes: > >> In (info "(org) References"), there is an example explaining the range >> references: >> >> @-1$-2..@-1 3 numbers from the column to the left, 2 up to >> current row >> >> What does `2 up to current row' mean? I don't understand. IIRC `@' >> represents row, it should be `1 up to current row'. > > No. The whole sentence expands to this: > > This range takes 3 numbers: the first one from the column to the > left (and the row above), the 2 others up to current row. > > I agree this might not be obvious but I don't have a better proposal. > Maybe a native english speaker can help here. > > Best, I think the current description is wrong and that rows and columns have been interchanged? The entries defined by this range are all in the row above (@-1) the current row. The columns chosen are two to the left of the current column up to the current column. If you wish to re-word, maybe: This range expands to three elements, all on the row above the current row, starting with the column two to the left of the current column. -- : Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D : in Emacs 24.3.50.1 and Org release_7.9.3d-874-gf11acc