Re: [O] making flexible table formulas

2011-03-01 Thread Carsten Dominik
On 28.2.2011, at 18:35, Rustom Mody wrote: When using orgmode for hacking on data in a table (org a la spreadsheet) I have this situation Say I am concentrating on column 2 and I want the bottom cell to be the sum of the above cells For a 7 row table with 8th row having the total I get

[O] making flexible table formulas

2011-02-28 Thread Rustom Mody
When using orgmode for hacking on data in a table (org a la spreadsheet) I have this situation Say I am concentrating on column 2 and I want the bottom cell to be the sum of the above cells For a 7 row table with 8th row having the total I get #+TBLFM: @8$2=vsum(@1$2..@7$2) But now I have a

Re: [O] making flexible table formulas

2011-02-28 Thread Nick Dokos
Rustom Mody rustompm...@gmail.com wrote: When using orgmode for hacking on data in a table (org a la spreadsheet)  I have this situation Say I am concentrating on column 2 and I want the bottom cell to be the sum of the above cells For a 7 row table with 8th row having the total I get  

Re: [O] making flexible table formulas

2011-02-28 Thread Luke Crook
On Mon, Feb 28, 2011 at 9:35 AM, Rustom Mody rustompm...@gmail.com wrote: When using orgmode for hacking on data in a table (org a la spreadsheet) I have this situation Say I am concentrating on column 2 and I want the bottom cell to be the sum of the above cells For a 7 row table with 8th

Re: [O] making flexible table formulas

2011-02-28 Thread Rustom Mody
Nick Dokos wrote: Of course it's reasonable - and of course, org implements it #+TBLFM: $LR2=vsum(@1..@-1) Thanks Nick I can use that. But I dont understand it. What's the -1? The manual says -- relative to 'current' column. What determines 'current?' There must be some obvious POV which I am

Re: [O] making flexible table formulas

2011-02-28 Thread theo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/2011 04:19, Rustom Mody wrote: Nick Dokos wrote: Of course it's reasonable - and of course, org implements it #+TBLFM: $LR2=vsum(@1..@-1) Thanks Nick I can use that. But I dont understand it. What's the -1? The manual says --

Re: [O] making flexible table formulas

2011-02-28 Thread Nick Dokos
Rustom Mody rustompm...@gmail.com wrote: Nick Dokos wrote: Of course it's reasonable - and of course, org implements it #+TBLFM: $LR2=vsum(@1..@-1) Thanks Nick I can use that. But I dont understand it. What's the -1? The manual says -- relative to 'current' column. What determines