emacs-orgmode
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]