[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] different result in spreadsheet tutorial
From: |
Carsten Dominik |
Subject: |
Re: [Orgmode] different result in spreadsheet tutorial |
Date: |
Tue, 14 Sep 2010 14:37:48 +0200 |
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(@address@hidden)::@5$3=vmean(@address@hidden)
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.
address@hidden
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- Carsten