From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Row formula in orgtbl mode
Date: Wed, 4 May 2011 17:26:14 +0200
Message-ID: <BANLkTiniunvFp+pXEctNTjjbO30KxHtmog@mail.gmail.com>
References: <4dc15635.1107df0a.51c0.15c4@mx.google.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:40891)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHdxw-0003hn-Lm
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 11:26:19 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHdxv-0004OE-HI
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 11:26:16 -0400
Received: from mail-ew0-f41.google.com ([209.85.215.41]:57994)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHdxv-0004O5-Cp
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 11:26:15 -0400
Received: by ewy9 with SMTP id 9so424959ewy.0
	for <emacs-orgmode@gnu.org>; Wed, 04 May 2011 08:26:14 -0700 (PDT)
In-Reply-To: <4dc15635.1107df0a.51c0.15c4@mx.google.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Michael Bach <phaebz@gmail.com>
Cc: emacs-orgmode@gnu.org

Hi Michael

On Wed, May 4, 2011 at 15:35, Michael Bach <phaebz@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