From mboxrd@z Thu Jan 1 00:00:00 1970 From: RCY Subject: Re: Spreadsheet row formula Date: Sun, 8 Jan 2012 11:12:15 -0500 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8fb2083eacf7b504b6068bf9 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:54883) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RjvM2-0007Ey-4Z for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:12:18 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1RjvM1-00018R-8r for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:12:18 -0500 Received: from mail-pw0-f41.google.com ([209.85.160.41]:42142) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RjvM1-00018L-2n for emacs-orgmode@gnu.org; Sun, 08 Jan 2012 11:12:17 -0500 Received: by pbdd2 with SMTP id d2so2600007pbd.0 for ; Sun, 08 Jan 2012 08:12:16 -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 --e89a8fb2083eacf7b504b6068bf9 Content-Type: text/plain; charset=ISO-8859-1 Hi, 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. 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 But that did not work. Thanks. On Sun, Jan 8, 2012 at 10:51 AM, Michael Brand wrote: > Hi RCY > > Do you want to do this?: > > | A | 2 | 3 | 4 | > | B | 4 | 6 | 8 | > | C | 8 | 12 | 16 | > #+TBLFM: @<<$<<..@>$> = 2 * @-1 > > > Michael > --e89a8fb2083eacf7b504b6068bf9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,
=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 t= he 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 formula to every row. I would like to appl= y different row formulas to succeeding rows.
Also I was not clear about = the syntax you used, does <<$<< exclude the first column and &g= t;$> indicate up to the last column?
I tried to modify your formula to restrict it to the second row: @2<<= $<<..@2>$> =3D 2 * @-1
But that did not work.

Thanks.=

On Sun, Jan 8, 2012 at 10:51 AM, Michael= Brand <= michael.ch.brand@gmail.com> wrote:
Hi RCY

Do you want to do this?:

| A | 2 | =A03 | =A04 |
| B | 4 | =A06 | =A08 |
| C | 8 | 12 | 16 |
#+TBLFM: @<<$<<..@>$> =3D 2 * @-1


Michael

--e89a8fb2083eacf7b504b6068bf9--