From: Carsten Dominik <carsten.dominik@gmail.com>
To: Stuart McLean <smclean0640@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: different result in spreadsheet tutorial
Date: Tue, 14 Sep 2010 14:37:48 +0200 [thread overview]
Message-ID: <9395BD8A-F44C-4835-8324-7A1285449DAA@gmail.com> (raw)
In-Reply-To: <87bp80frlw.fsf@horrorshow.hypnokush>
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
prev parent reply other threads:[~2010-09-14 12:37 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-09-14 12:15 different result in spreadsheet tutorial Stuart McLean
2010-09-14 12:37 ` Carsten Dominik [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=9395BD8A-F44C-4835-8324-7A1285449DAA@gmail.com \
--to=carsten.dominik@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=smclean0640@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).