From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Spreadsheet row formula
Date: Sun, 8 Jan 2012 17:23:55 +0100
Message-ID: <CALn3zogKTPAn3ihQeSidYVojSewVjjWTA2ssCufTGCcgBjwNGg@mail.gmail.com>
References: <CAD_Xbc4_ZvGe70hho26jZngiQsWumLxFdXmzm_TZ6X80ruvc5A@mail.gmail.com>
	<CALn3zoiR5zENp-Ho=9eMRYVFjgbjvE-oxMTACkDTVyt57uUQ-w@mail.gmail.com>
	<CAD_Xbc5vWtLZ2Y6Avh=Z1iz6JvEZKOqj9Uxx6gU=SEtvHwjD=g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:52355)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RjvXJ-0003C4-PU
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:23:58 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RjvXI-0002h5-Kk
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:23:57 -0500
Received: from mail-ww0-f49.google.com ([74.125.82.49]:57494)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RjvXI-0002h0-EB
	for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:23:56 -0500
Received: by wgbdt13 with SMTP id dt13so696833wgb.30
	for <emacs-orgmode@gnu.org>; Sun, 08 Jan 2012 08:23:55 -0800 (PST)
In-Reply-To: <CAD_Xbc5vWtLZ2Y6Avh=Z1iz6JvEZKOqj9Uxx6gU=SEtvHwjD=g@mail.gmail.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: <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: RCY <recif@yahoo.com>
Cc: OM <emacs-orgmode@gnu.org>

Hi RCY

On Sun, Jan 8, 2012 at 17:12, RCY <recif@yahoo.com> wrote:
> =A0Sorry not to be clearer.
> I would like to implement the formula for only one row. So entering the
> first row shown below and implementing the formula with only B entered in
> the first column in the second row gives the rest of the second row.
>
>
> =A0|A|2|3|4|
> =A0|B|4|6|8|
>
> Your suggestion almost does what I want, except that it applies the formu=
la
> to every row. I would like to apply different row formulas to succeeding
> rows.

So you want this:

| A | 2 | 3 | 4 |
| B | 4 | 6 | 8 |
#+TBLFM: @2$<<..@2$> =3D 2 * @-1

> Also I was not clear about the syntax you used, does <<$<< exclude the fi=
rst
> column and >$> indicate up to the last column?
> I tried to modify your formula to restrict it to the second row:
> @2<<$<<..@2>$> =3D 2 * @-1

@< first row
$<< second column
$> last column
@>> second last row
[...]

See also the manual here:
http://orgmode.org/manual/References.html

Michael