From: Carsten Dominik <carsten.dominik@gmail.com>
To: Eddward DeVilla <eddward@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: table formula w/o calc
Date: Sun, 17 Dec 2006 12:10:28 +0100 [thread overview]
Message-ID: <babc9fd90211f36b575308f8ec013885@science.uva.nl> (raw)
In-Reply-To: <b71b18520612152114x5a9198e1jf1a6fd41ac98bf2d@mail.gmail.com>
On Dec 16, 2006, at 6:14, Eddward DeVilla wrote:
> On 12/15/06, Xiao-Yong Jin <xj2106@columbia.edu> wrote:
>> "Eddward DeVilla" <eddward@gmail.com> writes:
>> Maybe you've already tried this. But I guess it's still worth
>> mentioning. You probably need a `#' in the first row as following
>>
>> |---+------+----+----+----+----------------|
>> | | name | P1 | P2 | P3 | TOT |
>> |---+------+----+----+----+----------------|
>> | # | Al | 10 | 9 | 8 | ='(+ $3 $4 $5) |
>> | # | Bob | 9 | 8 | 10 | |
>> | # | Carl | 8 | 10 | 9 | |
>> | # | Dan | 10 | 10 | 10 | |
>> |---+------+----+----+----+----------------|
>
> Not sure if I've done this variation before. Just tried now without
> luck. Thanks for the suggestion though.
You don't necessarily need these markers in the first column.
To evaluate the equation, simply put the cursor into the field
where you have typed the equation, and press either TAB or RET.
This will store the equation in a #TBLFM line below the table and
replace it in the table with the result of this calculation.
To get it applied to all line in the table, press `C-u C-c *', or,
alternatively, `C-u C-c C-c'.
This is in the manual, section 3.3 to be precise. But obviously
not explained clearly enough. Please, if you find time, read that part
and tell me what should have been there or anywhere else, so that you
would not have gotten stuck.
The # markers in the first line mean that each time you press
TAB, all equations in that line will be re-applied. This can be useful
if you have lots of equations, but it can slow down editing.
- Carsten
--
Carsten Dominik
Sterrenkundig Instituut "Anton Pannekoek"
Universiteit van Amsterdam
Kruislaan 403
NL-1098SJ Amsterdam
phone: +31 20 525 7477
prev parent reply other threads:[~2006-12-17 11:10 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2006-12-15 18:50 table formula w/o calc Eddward DeVilla
2006-12-15 20:25 ` Leo
2006-12-15 21:00 ` Eddward DeVilla
2006-12-15 21:48 ` Leo
2006-12-16 4:19 ` Xiao-Yong Jin
2006-12-16 5:14 ` Eddward DeVilla
2006-12-17 11:10 ` 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=babc9fd90211f36b575308f8ec013885@science.uva.nl \
--to=carsten.dominik@gmail.com \
--cc=eddward@gmail.com \
--cc=emacs-orgmode@gnu.org \
/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).