From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adam Spiers Subject: meaning of ampersand in spreadsheet cell references Date: Thu, 9 Sep 2010 10:20:30 +0100 Message-ID: <20100909092030.GA12903@atlantic.linksys.moosehall> Reply-To: Adam Spiers Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from [140.186.70.92] (port=54782 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OtdJA-0003qP-WD for emacs-orgmode@gnu.org; Thu, 09 Sep 2010 05:20:42 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OtdJ9-0007hi-Ty for emacs-orgmode@gnu.org; Thu, 09 Sep 2010 05:20:40 -0400 Received: from arctic.adamspiers.org ([212.13.194.176]:50558) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OtdJ9-0007hA-Ol for emacs-orgmode@gnu.org; Thu, 09 Sep 2010 05:20:39 -0400 Received: from localhost (dsl-217-155-199-114.zen.co.uk [217.155.199.114]) by arctic.adamspiers.org (Postfix) with ESMTP id 023762403F for ; Thu, 9 Sep 2010 09:20:35 +0000 (UTC) Content-Disposition: inline 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: org-mode mailing list Hi all, The manual refers fleetingly to the use of ampersand in spreadsheet cell references. Amongst other cell reference examples, it lists: $5 column 5 in the current row E& same as previous The only other mention I can find is: When offering a formula for editing, Org converts references to the standard format (like `B3' or `D&') if possible. I assume this means that ampersand can replace the number in cell references of the format `B3' to means "the current row"? However this doesn't seem to tie in with any of the other syntax listed, and therefore maybe warrants a slightly more explicit explanation in the manual? Thanks! Adam