Re: [O] Row formula in orgtbl mode
Michael Brand michael.ch.br...@gmail.com 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
[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
[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
Re: [O] Row formula in orgtbl mode
Hi Michael On Wed, May 4, 2011 at 15:25, Michael Bach pha...@gmail.com 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
Re: [O] Row formula in orgtbl mode
Hi Michael On Wed, May 4, 2011 at 15:35, Michael Bach pha...@gmail.com 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