[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Row formula in orgtbl mode
From: |
Michael Brand |
Subject: |
Re: [O] Row formula in orgtbl mode |
Date: |
Wed, 4 May 2011 17:26:14 +0200 |
Hi Michael
On Wed, May 4, 2011 at 15:35, Michael Bach <address@hidden> 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: @address@hidden@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
> @address@hidden@address@hidden, fail.
Your range formula @address@hidden@address@hidden 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: @address@hidden@address@hidden
For this application I would suggest
#+TBLFM: @4$<<address@hidden>address@hidden@-2
Michael