From mboxrd@z Thu Jan 1 00:00:00 1970 From: Russell Adams Subject: Re: table spreadsheet problem Date: Mon, 19 Mar 2012 11:05:17 -0500 Message-ID: <20120319160517.GX31713@x201> References: <20120319153221.GN31713@x201> <17453.1332172608@alphaville> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([208.118.235.92]:56522) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S9f5t-0007H1-Rn for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 12:06:06 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1S9f5l-0004rX-7W for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 12:06:01 -0400 Received: from jack.asmallorange.com ([74.52.119.82]:36123) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S9f5l-0004rH-2a for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 12:05:53 -0400 Received: from 206.180.155.43.adsl.hal-pc.org ([206.180.155.43] helo=localhost) by jack.asmallorange.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69) (envelope-from ) id 1S9f5i-004DGE-2g for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 12:05:50 -0400 Content-Disposition: inline In-Reply-To: <17453.1332172608@alphaville> 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 > 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! ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3