From mboxrd@z Thu Jan 1 00:00:00 1970 From: RCY Subject: Re: Spreadsheet row formula Date: Sun, 8 Jan 2012 11:37:36 -0500 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8f234c1f4e094d04b606e675 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:34974) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RjvkZ-0005IR-2K for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:37:40 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1RjvkX-0004Iv-Te for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:37:38 -0500 Received: from mail-pz0-f41.google.com ([209.85.210.41]:54485) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RjvkX-0004Im-NW for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:37:37 -0500 Received: by dakl33 with SMTP id l33so2580525dak.0 for ; Sun, 08 Jan 2012 08:37:36 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Brand Cc: OM --e89a8f234c1f4e094d04b606e675 Content-Type: text/plain; charset=ISO-8859-1 Hi, That does what I want. Thanks for taking the time to explain it. I should have read the manual on relative cell references more carefully. On Sun, Jan 8, 2012 at 11:23 AM, Michael Brand wrote: > Hi RCY > > On Sun, Jan 8, 2012 at 17:12, RCY wrote: > > Sorry 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. > > > > > > |A|2|3|4| > > |B|4|6|8| > > > > Your suggestion almost does what I want, except that it applies the > formula > > 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$> = 2 * @-1 > > > Also I was not clear about the syntax you used, does <<$<< exclude the > first > > column and >$> indicate up to the last column? > > I tried to modify your formula to restrict it to the second row: > > @2<<$<<..@2>$> = 2 * @-1 > > @< first row > $<< second column > $> last column > @>> second last row > [...] > > See also the manual here: > http://orgmode.org/manual/References.html > > Michael > --e89a8f234c1f4e094d04b606e675 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,
=A0That does what I want. Thanks for taking the time to explain it. = I should have read the manual on relative cell references more carefully.
On Sun, Jan 8, 2012 at 11:23 AM, Michael B= rand <mi= chael.ch.brand@gmail.com> wrote:
Hi RCY

On Sun, Jan 8, 2012 at 17:12, RCY <re= cif@yahoo.com> wrote:
> =A0Sorry not to be clearer.
> I would like to implement the formula for only one row. So entering th= e
> 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 fo= rmula
> to every row. I would like to apply different row formulas to succeedi= ng
> 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 first
> 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:
htt= p://orgmode.org/manual/References.html

Michael

--e89a8f234c1f4e094d04b606e675--