From mboxrd@z Thu Jan 1 00:00:00 1970 From: Greg Minshall Subject: spreadsheet hline-relative (I) field references Date: Thu, 02 May 2013 16:48:14 -0400 Message-ID: <27059.1367527694@greg-minshalls-mbp.local> Return-path: Received: from eggs.gnu.org ([208.118.235.92]:44947) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UY0QN-0001VF-Vn for emacs-orgmode@gnu.org; Thu, 02 May 2013 16:48:22 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UY0QL-0004Zh-FP for emacs-orgmode@gnu.org; Thu, 02 May 2013 16:48:19 -0400 Received: from relay03.pair.com ([209.68.5.17]:2373) by eggs.gnu.org with smtp (Exim 4.71) (envelope-from ) id 1UY0QL-0004Z7-9g for emacs-orgmode@gnu.org; Thu, 02 May 2013 16:48:17 -0400 Received: from greg-minshalls-mbp.local (localhost [127.0.0.1]) by gregair.cliq.com (Postfix) with ESMTP id 357F11162CC38 for ; Thu, 2 May 2013 16:48:15 -0400 (EDT) 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 hi. i've two suggestions/requests/queries about using hline-relative references, e.g., @III, in formulas in org-mode spreadsheets. 1. i would like to use this syntax on the *left* hand side of a formula. e.g., ---- #+TBLFM: @I$2=vsum(@-I$1..@+I$1) ---- (meaning, the second column in the first row after the first hline gets the sum of all the first columns in the rows between the first and second hlines). 2. i have occasions where i would like to address hlines from the bottom, rather than from the top. is there a syntax for this? if not, maybe something like @Z (and all its friends, including @ZZZ, etc.)? comments? cheers, Greg