From: Andreas Burtzlaff <andy13@gmx.net>
To: meingbg <meingbg@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Spreadsheet bug?
Date: Thu, 23 Jul 2009 11:04:53 +0200 [thread overview]
Message-ID: <20090723110453.17994c2f.andy13@gmx.net> (raw)
In-Reply-To: <c91ecc400907221729o6a2b56e9g5ef83da195709bd5@mail.gmail.com>
On Thu, 23 Jul 2009 02:29:30 +0200
meingbg <meingbg@gmail.com> wrote:
> | a | b | c |
> |---+----+---|
> | a | 2 | 2 |
> | b | 3 | 7 |
> | c | -3 | 4 |
> | d | 5 | 9 |
> #+TBLFM: $3=$2+@-1::@2$3=$2
A good solution is to use
$3=vsum(@-I$-1..$-1)
as proposed in this thread:
http://thread.gmane.org/gmane.emacs.orgmode/1940/focus=1941
Nevertheless:
If @2$3 is manually set to 2 in the table, then the formulas produce
the expected outcome. So, the problem seems to be the order of
execution. If column c is cleared and the formulas are executed, @2$3
is read to be 0 for the summation and is set to 2 only afterwards.
Swapping the order in the TBLFM line doesn't help.
Is the order something like field formulas after column formulas?
Any chance to influence that?
Andy
next prev parent reply other threads:[~2009-07-23 9:04 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-07-23 0:29 Spreadsheet bug? meingbg
2009-07-23 9:04 ` Andreas Burtzlaff [this message]
-- strict thread matches above, loose matches on Subject: below --
2009-07-23 10:17 meingbg
2009-07-23 10:39 ` Andreas Burtzlaff
2009-07-24 15:20 ` meingbg
[not found] <20090723160554.5AA76324F7@mailhost.cs.tu-berlin.de>
2009-07-24 9:20 ` Stephan Schmitt
2009-08-03 4:31 ` Carsten Dominik
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=20090723110453.17994c2f.andy13@gmx.net \
--to=andy13@gmx.net \
--cc=emacs-orgmode@gnu.org \
--cc=meingbg@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).