From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stuart McLean Subject: different result in spreadsheet tutorial Date: Tue, 14 Sep 2010 05:15:55 -0700 Message-ID: <87bp80frlw.fsf@horrorshow.hypnokush> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from [140.186.70.92] (port=33206 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OvUeF-0003qJ-VU for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:30:09 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OvUeE-0002VR-C6 for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:30:07 -0400 Received: from lo.gmane.org ([80.91.229.12]:38381) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OvUeE-0002VF-1h for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 08:30:06 -0400 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1OvUeB-0005G7-V8 for emacs-orgmode@gnu.org; Tue, 14 Sep 2010 14:30:04 +0200 Received: from s0106001636ac5854.gv.shawcable.net ([24.69.99.248]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 14 Sep 2010 14:30:03 +0200 Received: from smclean0640 by s0106001636ac5854.gv.shawcable.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 14 Sep 2010 14:30:03 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org 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. Am I doing something wrong? Please excuse if this has been covered earlier in the newsgroup Thanks, Stuart