[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table spreadsheet problem
From: |
Russell Adams |
Subject: |
Re: [O] table spreadsheet problem |
Date: |
Mon, 19 Mar 2012 11:05:17 -0500 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
> 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(@address@hidden);%.2f::@>>$>=@>>>$>*0.08;%.2f::@>$>=vsum(@address@hidden);%.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 address@hidden
PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3