Re: [O] Row formula in orgtbl mode
Michael Brand writes: > Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at > least to this commitdiff > http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538 I am now running the 7.5 development version checked out today. I knew I would have to do this one day... > | |a |b |c |d | > | Specific cost |1 |9 |2 |3 | > | System size | 1000 | 1000 | 1000 | 1000 | > | | 1000 | 9000 | 2000 | 3000 | > | ... | ... | ... | ... | ... | > #+TBLFM: @4$2..@4$5=@-1*@-2 > > For this application I would suggest > #+TBLFM: @4$<<..@4$>=@-1*@-2 Thanks for the quick and competent answer Michael, it worked right away. MB
Re: [O] Row formula in orgtbl mode
Hi Michael On Wed, May 4, 2011 at 15:35, Michael Bach wrote: > # I sent this one previously by mistake in reply to a totally unrelated post, > so now > # again. # and also the answer again for the mail archives with this thread separate > | |a |b |c |d | > | Specific cost |1 |9 |2 |3 | > | System size | 1000 | 1000 | 1000 | 1000 | > | | | | | | > | ... | ... | ... | ... | ... | > #+TBLFM: @4=@2*@3 Row formulas are not supported, but the new range formulas you already tried are even more powerful: > I am wondering how I would need to format the #+TBLFM: line to multiply > the respective numeric values of rows 2 and 3 in row 4. I am using org > v.7.4. All my attempts, also trying to define ranges like > @4$2..@4$5=@-1*@-2, fail. Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at least to this commitdiff http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538 and will deliver | |a |b |c |d | | Specific cost |1 |9 |2 |3 | | System size | 1000 | 1000 | 1000 | 1000 | | | 1000 | 9000 | 2000 | 3000 | | ... | ... | ... | ... | ... | #+TBLFM: @4$2..@4$5=@-1*@-2 For this application I would suggest #+TBLFM: @4$<<..@4$>=@-1*@-2 Michael
Re: [O] Row formula in orgtbl mode
Hi Michael On Wed, May 4, 2011 at 15:25, Michael Bach wrote: > | | a | b | c | d | > | Specific cost | 1 | 9 | 2 | 3 | > | System size | 1000 | 1000 | 1000 | 1000 | > | | | | | | > | ... | ... | ... | ... | ... | > #+TBLFM: @4=@2*@3 Row formulas are not supported, but the new range formulas you already tried are even more powerful: > I am wondering how I would need to format the #+TBLFM: line to multiply > the respective numeric values of rows 2 and 3 in row 4. I am using org > v.7.4. All my attempts, also trying to define ranges like > @4$2..@4$5=@-1*@-2, fail. Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at least to this commitdiff http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538 and will deliver | |a |b |c |d | | Specific cost |1 |9 |2 |3 | | System size | 1000 | 1000 | 1000 | 1000 | | | 1000 | 9000 | 2000 | 3000 | | ... | ... | ... | ... | ... | #+TBLFM: @4$2..@4$5=@-1*@-2 For this application I would suggest #+TBLFM: @4$<<..@4$>=@-1*@-2 Michael
[O] Row formula in orgtbl mode
# I sent this one previously by mistake in reply to a totally unrelated post, so now # again. Dear org-mode Users, Given this table | |a |b |c |d | | Specific cost |1 |9 |2 |3 | | System size | 1000 | 1000 | 1000 | 1000 | | | | | | | | ... | ... | ... | ... | ... | #+TBLFM: @4=@2*@3 I am wondering how I would need to format the #+TBLFM: line to multiply the respective numeric values of rows 2 and 3 in row 4. I am using org v.7.4. All my attempts, also trying to define ranges like @4$2..@4$5=@-1*@-2, fail. Thanks in advance, Michael Bach
[O] Row formula in orgtbl mode
Dear org-mode Users, Given this table | |a |b |c |d | | Specific cost |1 |9 |2 |3 | | System size | 1000 | 1000 | 1000 | 1000 | | | | | | | | ... | ... | ... | ... | ... | #+TBLFM: @4=@2*@3 I am wondering how I would need to format the #+TBLFM: line to multiply the respective numeric values of rows 2 and 3 in row 4. I am using org v.7.4. All my attempts, also trying to define ranges like @4$2..@4$5=@-1*@-2, fail. Thanks in advance, Michael Bach