Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Carsten Dominik
On 3.3.2011, at 23:11, Nick Dokos wrote: > Suvayu Ali wrote: > >> Hi, >> >> On Thu, 3 Mar 2011 22:19:32 +0100 >> Carsten Dominik wrote: >> >>> >>> On 3.3.2011, at 05:18, Nick Dokos wrote: >>> Carsten Dominik wrote: > Maybe we should use something else to achieve symmetry, l

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Suvayu Ali
Hi Nick, On Thu, 03 Mar 2011 17:11:00 -0500 Nick Dokos wrote: > > #+TBLFM: @>$>=vsum(@I..@II);%.2f > > > > It doesn't work. Whereas this does: > > > > ... > > > > #+TBLFM: @5$2=vsum(@I..@II);%.2f > > > > Am I doing something wrong? > > > > I don't think so: I don't see Carsten's change eve

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Nick Dokos
Suvayu Ali wrote: > Hi, > > On Thu, 3 Mar 2011 22:19:32 +0100 > Carsten Dominik wrote: > > > > > On 3.3.2011, at 05:18, Nick Dokos wrote: > > > > > Carsten Dominik wrote: > > > > > >> Maybe we should use something else to achieve symmetry, like @> > > >> and $>. > > >> > > >> Comments? >

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Suvayu Ali
Hi, On Thu, 3 Mar 2011 22:19:32 +0100 Carsten Dominik wrote: > > On 3.3.2011, at 05:18, Nick Dokos wrote: > > > Carsten Dominik wrote: > > > >> Maybe we should use something else to achieve symmetry, like @> > >> and $>. > >> > >> Comments? > >> > > > > Perfect. Mirrors the keybinding for

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Carsten Dominik
On 3.3.2011, at 05:18, Nick Dokos wrote: > Carsten Dominik wrote: > >> Maybe we should use something else to achieve symmetry, like @> and $>. >> >> Comments? >> > > Perfect. Mirrors the keybinding for end-of-buffer, so there is mnemonic > value there, and it naturally flows from the @N$N n

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Bastien
Carsten Dominik writes: >> FWIW I also find @> and $> to be better than @L and $L. > > OK, I will include this change into my next patch. Thanks!! -- Bastien

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Carsten Dominik
On 3.3.2011, at 05:18, Nick Dokos wrote: > Carsten Dominik wrote: > >> Maybe we should use something else to achieve symmetry, like @> and $>. >> >> Comments? >> > > Perfect. Mirrors the keybinding for end-of-buffer, so there is mnemonic > value there, and it naturally flows from the @N$N n

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Carsten Dominik
On 3.3.2011, at 09:28, Bastien wrote: > Nick Dokos writes: > >> Carsten Dominik wrote: >> >>> Maybe we should use something else to achieve symmetry, like @> and $>. >>> >>> Comments? >>> >> >> Perfect. Mirrors the keybinding for end-of-buffer, so there is mnemonic >> value there, and it

Re: [O] Table rows and ranges as LHS of formulas

2011-03-03 Thread Bastien
Nick Dokos writes: > Carsten Dominik wrote: > >> Maybe we should use something else to achieve symmetry, like @> and $>. >> >> Comments? >> > > Perfect. Mirrors the keybinding for end-of-buffer, so there is mnemonic > value there, and it naturally flows from the @N$N notation. FWIW I also fi

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Nick Dokos
Carsten Dominik wrote: > Maybe we should use something else to achieve symmetry, like @> and $>. > > Comments? > Perfect. Mirrors the keybinding for end-of-buffer, so there is mnemonic value there, and it naturally flows from the @N$N notation. Something else that popped into my head: are th

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Carsten Dominik
On 3.3.2011, at 00:09, Christian Moe wrote: > Hi, Carsten, > > Yes, it's really neat. > > I just realized, though, that there *is* an equally clean way to generate > such tables in OOo Calc (which the Org spreadsheet has all but replaced for > my needs): > > - Place 1 in cell B1. Drag across

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Samuel Wales
On 2011-03-02, Carsten Dominik wrote: > Maybe we should use something else to achieve symmetry, like @> and $>. Dunno if this comment helps, but I like predictable behavior, so that should work. -- The Kafka Pandemic: http://thekafkapandemic.blogspot.com/2010/12/welcome-to-kafka-pandemic-two-f

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Christian Moe
Hi, Carsten, Yes, it's really neat. I just realized, though, that there *is* an equally clean way to generate such tables in OOo Calc (which the Org spreadsheet has all but replaced for my needs): - Place 1 in cell B1. Drag across to get 1-10 in cells B1:K1. - Place 1 in cell A2. Drag down t

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Carsten Dominik
On 2.3.2011, at 19:54, Nick Dokos wrote: > Carsten Dominik wrote: > >> >> On 2.3.2011, at 18:21, Bastien wrote: >> >>> Hi Carsten, >>> >>> Carsten Dominik writes: >>> Bastien, please let me know if you want to have this integrated before the release, then I will do so. >>> >>> P

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Suvayu Ali
Hi Nick, On Wed, 02 Mar 2011 13:54:09 -0500 Nick Dokos wrote: > One nit: symmetry dictates that $L should be the last column, but it > isn't. Trying @2$2..@L$11 in Christian's example works fine, but > @2$2..@L$L changes the first column to all zeroes (not sure why). I can't find a reference t

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Nick Dokos
Carsten Dominik wrote: > > On 2.3.2011, at 18:21, Bastien wrote: > > > Hi Carsten, > > > > Carsten Dominik writes: > > > >> Bastien, please let me know if you want to have this integrated > >> before the release, then I will do so. > > > > Please go ahead! This looks like a nice addition,

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Carsten Dominik
On 2.3.2011, at 18:21, Bastien wrote: > Hi Carsten, > > Carsten Dominik writes: > >> Bastien, please let me know if you want to have this integrated >> before the release, then I will do so. > > Please go ahead! This looks like a nice addition, thanks for that. I just pushed it. The patch

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Carsten Dominik
Hi Christian, thanks for the great example! I guess this is really something Org has over other spreadsheets. No copy-and-paste-with-modification, just a single formula. - Carsten On 2.3.2011, at 17:11, Christian Moe wrote: > Hi, > > Row formulas are great! I've missed this, but learned to

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Bastien
Hi Carsten, Carsten Dominik writes: > Bastien, please let me know if you want to have this integrated > before the release, then I will do so. Please go ahead! This looks like a nice addition, thanks for that. -- Bastien ___ Emacs-orgmode mailing

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Bernt Hansen
Hi Carsten, This is really cool! Thanks and Best Regards, Bernt Christian Moe writes: > Hi, > > Row formulas are great! I've missed this, but learned to work around > it, since I I just assumed that if you hadn't already done it, it was > not a reasonable thing to ask for. > > Testing... So

Re: [O] Table rows and ranges as LHS of formulas

2011-03-02 Thread Christian Moe
Hi, Row formulas are great! I've missed this, but learned to work around it, since I I just assumed that if you hadn't already done it, it was not a reasonable thing to ask for. Testing... So now we can simply do e.g.: #+CAPTION: A multiplication table || 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |