From mboxrd@z Thu Jan  1 00:00:00 1970
From: RCY <recif@yahoo.com>
Subject: Spreadsheet row formula
Date: Sun, 8 Jan 2012 10:39:38 -0500
Message-ID: <CAD_Xbc4_ZvGe70hho26jZngiQsWumLxFdXmzm_TZ6X80ruvc5A@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=e89a8ff24d9f0751c504b6061709
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:52489)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <recifx@gmail.com>) id 1RjuqU-0005mt-AI
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 10:39:43 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <recifx@gmail.com>) id 1RjuqT-0002ij-An
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 10:39:42 -0500
Received: from mail-pw0-f41.google.com ([209.85.160.41]:62750)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <recifx@gmail.com>) id 1RjuqS-0002iU-Vl
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 10:39:41 -0500
Received: by pbdd2 with SMTP id d2so2589459pbd.0
	for <emacs-orgmode@gnu.org>; Sun, 08 Jan 2012 07:39:39 -0800 (PST)
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: <http://lists.gnu.org/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: OM <emacs-orgmode@gnu.org>

--e89a8ff24d9f0751c504b6061709
Content-Type: text/plain; charset=ISO-8859-1

In the following table I am trying to implement a row formula for each cell
to be a multiple of the corresponding cell in a preceding row, but several
variations I tried do not work:

| A    | 2          | 3          | 4            |
| B    | [4, 6, 8] | [4, 6, 8] | [4, 6, 8] |
| C    | [4, 6, 8] | [4, 6, 8] | [4, 6, 8] |
| 2 A |           4 |         6  |           8 |
#+TBLFM: @2$2..@2$4=2*@1$2..@1$4::@3$2..@3$4=2*(@1$2..@1$4)



What I would like to get, without having to repeat the formula for each
cell in the row is:
|B|4|6|8|

It seems that this should be fairly simple to do. I am using the latest git
version of orgmode with emacs 24.0.50
Thanks for any suggestions.

--e89a8ff24d9f0751c504b6061709
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

In the following table I am trying to implement a row formula for each cell=
 to be a multiple of the corresponding cell in a preceding row, but several=
 variations I tried do not work:<br><br>| A=A0=A0=A0 | 2=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 | 3=A0=A0=A0=A0=A0=A0=A0=A0=A0 | 4=A0 =A0=A0 =A0=A0=A0 =A0=A0 |<b=
r>
| B=A0=A0=A0 | [4, 6, 8] | [4, 6, 8] | [4, 6, 8] |<br>| C =A0=A0 | [4, 6, 8=
] | [4, 6, 8] | [4, 6, 8] |<br>| 2 A |=A0=A0=A0=A0=A0 =A0=A0 =A0 4 |=A0=A0=
=A0=A0=A0=A0=A0=A0 6=A0 |=A0=A0 =A0 =A0=A0 =A0=A0 8 |<br>#+TBLFM: @2$2..@2$=
4=3D2*@1$2..@1$4::@3$2..@3$4=3D2*(@1$2..@1$4)<br><br><br><br>
What I would like to get, without having to repeat the formula for each cel=
l in the row is:<br>|B|4|6|8|<br><br>It seems that this should be fairly si=
mple to do. I am using the latest git version of orgmode with emacs 24.0.50=
<br>
Thanks for any suggestions.<br>

--e89a8ff24d9f0751c504b6061709--