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 g

Re: [O] making flexible table formulas

2011-02-28 Thread Nick Dokos
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 -- relative to 'current' column. > What determines 'current?' The

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 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 a

Re: [O] making flexible table formulas

2011-02-28 Thread Luke Crook
On Mon, Feb 28, 2011 at 9:35 AM, 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 to

Re: [O] making flexible table formulas

2011-02-28 Thread Nick Dokos
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 > >   #+TBLFM: @8$2=