From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nick Dokos Subject: Re: table spreadsheet problem Date: Mon, 19 Mar 2012 13:42:50 -0400 Message-ID: <2758.1332178970@alphaville> References: <20120319153221.GN31713@x201> <17453.1332172608@alphaville> <20120319160517.GX31713@x201> Reply-To: nicholas.dokos@hp.com Return-path: Received: from eggs.gnu.org ([208.118.235.92]:44232) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S9gbj-0000um-Bn for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 13:43:19 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1S9gbe-000676-Cm for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 13:42:58 -0400 Received: from g1t0029.austin.hp.com ([15.216.28.36]:25970) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S9gbe-00066w-7L for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 13:42:54 -0400 Received: from g1t0038.austin.hp.com (g1t0038.austin.hp.com [16.236.32.44]) by g1t0029.austin.hp.com (Postfix) with ESMTP id DC271383C5 for ; Mon, 19 Mar 2012 17:42:51 +0000 (UTC) In-Reply-To: Message from Russell Adams of "Mon, 19 Mar 2012 11:05:17 CDT." <20120319160517.GX31713@x201> 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 Cc: nicholas.dokos@hp.com Russell Adams wrote: > > Nowadays, you can use (both on the LHS and the RHS of the formula) > > symbolic references relative to the first, second, third ... row like > > this: @<, @<<, @<< ... and relative to the last, penultimate, > > antepenultimate (is there such a word?) row like this: @>, @>>, @>>> > > ..., and similarly for columns, so you could write the formula, like > > this: > > > > #+TBLFM: @>>>$>=vsum(@-I..@-II);%.2f::@>>$>=@>>>$>*0.08;%.2f::@>$>=vsum(@-I..@-II);%.2f > > > > This *does* require iterated evaluations, so C-u C-u C-c C-c is your > > best bet, to make sure everything is updated properly. > > > > Nick > > What version was that introduced in? I know I haven't kept on the > bleeding edge, and I tried that just this past week and it didn't > work. I was hoping for it! > It was introduced about a year ago, so it should be in 7.7 or later (possibly some earlier releases as well but I haven't checked in detail.) If you git, then the relevant commits are 5631a309ab567e0a6a059ce728f84c1637fd253f 3dd474575205d3808390fc6ea2d5feccdb3d4305 1432e4bc79f55ed21e8478284b6b7552736d0c22 The first two are the main ones - the last is a bug fix. Best bet is a fairly recent org (modulo all the git problems that people are trying to fix ATM). Nick