From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Chris Randle" <chris@amlog.co.uk>
Subject: RE: New tutorial about using Org as a spreadsheet system
Date: Wed, 27 Feb 2008 11:16:15 -0000
Message-ID: <00bb01c87932$2d6cf460$6580a8c0@CUBE>
References: <874pbvrxtg.fsf@bzg.ath.cx>
Mime-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1JUKHC-0004Ml-Vq
	for emacs-orgmode@gnu.org; Wed, 27 Feb 2008 06:16:43 -0500
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1JUKH9-0004M7-7k
	for emacs-orgmode@gnu.org; Wed, 27 Feb 2008 06:16:40 -0500
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1JUKH8-0004Lv-QI
	for emacs-orgmode@gnu.org; Wed, 27 Feb 2008 06:16:38 -0500
Received: from anchor-post-36.mail.demon.net ([194.217.242.86])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <chris@amlog.co.uk>) id 1JUKH8-0001ae-BX
	for emacs-orgmode@gnu.org; Wed, 27 Feb 2008 06:16:38 -0500
Received: from amlog.demon.co.uk ([80.177.106.135] helo=CUBE)
	by anchor-post-36.mail.demon.net with esmtp (Exim 4.67)
	id 1JUKH1-0004Wi-K7
	for emacs-orgmode@gnu.org; Wed, 27 Feb 2008 11:16:31 +0000
In-Reply-To: <874pbvrxtg.fsf@bzg.ath.cx>
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/pipermail/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: emacs-orgmode@gnu.org

Hi Bastien,

Bastien Guerry wrote:
> Hi folks,
> i've made a small tutorial about the use of spreadsheet facilities in
> org-mode:
>   http://www.legito.net/worg/org-tutorials/org-spreadsheet-intro.php

Thanks. It was very useful. I use tables and spreadsheets quite a lot,
but I still learnt a couple of very useful things that I didn't know:
the formula editor and debugging.

As I followed along, I spotted a couple of things:

1) Under "Your first formula", the first vmean formula you show is a
column formula, whereas the text implies it should have been a field
formula.

2) I'd never used #+CONSTANTS before, and as I followed along I
discovered that I had to do a 'C-c C-c' on the CONSTANTS line before the
table had knowledge of it. It might be good to make that explicit,
otherwise the table shows #ERRORs. I got to use my new-found debugging
knowledge to work out why!

-- 
Chris Randle