From: Carsten Dominik <dominik@science.uva.nl>
To: Pete Phillips <pete@smtl.co.uk>
Cc: org-mode mailing list <emacs-orgmode@gnu.org>
Subject: Re: problems with table mode
Date: Mon, 21 Apr 2008 08:13:12 +0200 [thread overview]
Message-ID: <28F7F848-17BF-462C-B89D-A9E110D1E0FB@science.uva.nl> (raw)
In-Reply-To: <18940.1208723747@localhost>
[-- Attachment #1.1: Type: text/plain, Size: 1336 bytes --]
On Apr 20, 2008, at 10:35 PM, Pete Phillips wrote:
> Evening Carsten
>>>>>> "Carsten" == Carsten Dominik <dominik@science.uva.nl> writes:
>
> Carsten> constructs like @III+1$2 are not allowed on the left side
> Carsten> of a formula. The left side must be either $N for a
> Carsten> column, or @M$N for a field. The error message stems from
> Carsten> the face that the scanner for formulas ignores the
> Carsten> @III... spec and reads both formulas as $2=....
>
>
> Hmm - so how do I tell it which is the correct cell to put the
> calculation in ? I've clearly missed something vital here.
>
> Pete
Hi Phil,
the correct formula line would be
#+TBLFM: @6$2=vsum(@II+1$2..@III-1$2)::@7$2=@1$2+@2$2-@III+1
Take a look at Bastien's tutorial about table calculations in Org:
http://legito.net/worg/org-tutorials/org-spreadsheet-intro.php
In order to make sure that the formula stays correct, you need to
make sure that you add more lines to the table only with the
proper command M-S-<down>. When using this command, the absolute
references in the formulas are modified.
I can see that a construct like you have been using would be
useful, because it would allow normal editing of the table and still
keep the correct results. I have taken a note, maybe this
can be implemented at some point.
HTH
- Carsten
[-- Attachment #1.2: Type: text/html, Size: 2443 bytes --]
[-- Attachment #2: Type: text/plain, Size: 204 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next prev parent reply other threads:[~2008-04-21 6:13 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-04-20 19:32 problems with table mode Pete Phillips
2008-04-20 20:27 ` Carsten Dominik
[not found] ` <18940.1208723747@localhost>
2008-04-21 6:13 ` Carsten Dominik [this message]
2008-04-21 6:38 ` Pete Phillips
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=28F7F848-17BF-462C-B89D-A9E110D1E0FB@science.uva.nl \
--to=dominik@science.uva.nl \
--cc=emacs-orgmode@gnu.org \
--cc=pete@smtl.co.uk \
/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).