From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <carsten.dominik@gmail.com>
Subject: Re: different result in spreadsheet tutorial
Date: Tue, 14 Sep 2010 14:37:48 +0200
Message-ID: <9395BD8A-F44C-4835-8324-7A1285449DAA@gmail.com>
References: <87bp80frlw.fsf@horrorshow.hypnokush>
Mime-Version: 1.0 (Apple Message framework v936)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=43849 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1OvUll-0007cr-GM
	for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:37:54 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <carsten.dominik@gmail.com>) id 1OvUlk-0003eB-6y
	for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:37:53 -0400
Received: from mail-ey0-f169.google.com ([209.85.215.169]:50843)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <carsten.dominik@gmail.com>) id 1OvUlk-0003dy-2X
	for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:37:52 -0400
Received: by eyh5 with SMTP id 5so3620728eyh.0
	for <emacs-orgmode@gnu.org>; Tue, 14 Sep 2010 05:37:51 -0700 (PDT)
In-Reply-To: <87bp80frlw.fsf@horrorshow.hypnokush>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Stuart McLean <smclean0640@gmail.com>
Cc: emacs-orgmode@gnu.org


On Sep 14, 2010, at 2:15 PM, Stuart McLean wrote:

> Hello,
>
> I am just beginning to learn org-mode's spreadsheet with the tutorial
> here: http://orgmode.org/worg/org-tutorials/org-spreadsheet-intro.php
>
> However, when I type C-c C-c on the TBLFM line below
>
>
>
>
> | Student  | Maths | Physics | Mean |
> |----------+-------+---------+------|
> | Bertrand |    13 |      09 |   11 |
> | Henri    |    15 |      14 | 14.5 |
> | Arnold   |    17 |      13 |   15 |
> |----------+-------+---------+------|
> | Means    |    15 |      12 |      |
> #+TBLFM:  
> $4=vmean($2..$3)::@5$2=vmean(@2$2..@4$2)::@5$3=vmean(@2$3..@4$3)
>
>
> I get 13.5 in D5. I assume $4=vmean($2..$3) is being computed for this
> row as well.

Yes, this is how column formulas work.

You can either use field formulas for the three fields, or you can  
overwrite the corner field with

    @5$4=string("")

HTH

- Carsten

> Am I doing something wrong?
>
> Please excuse if this has been covered earlier in the newsgroup
>
> Thanks,
>
> Stuart
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten