From mboxrd@z Thu Jan  1 00:00:00 1970
From: Andreas Burtzlaff <andy13@gmx.net>
Subject: Re: Spreadsheet bug?
Date: Thu, 23 Jul 2009 11:04:53 +0200
Message-ID: <20090723110453.17994c2f.andy13@gmx.net>
References: <c91ecc400907221729o6a2b56e9g5ef83da195709bd5@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MTuEL-0004yO-Qk
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 05:04:49 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MTuEH-0004ut-3O
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 05:04:49 -0400
Received: from [199.232.76.173] (port=50549 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MTuEG-0004uX-Os
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 05:04:44 -0400
Received: from mail.gmx.net ([213.165.64.20]:51353)
	by monty-python.gnu.org with smtp (Exim 4.60)
	(envelope-from <andy13@gmx.net>) id 1MTuEG-0002Sd-1J
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 05:04:44 -0400
In-Reply-To: <c91ecc400907221729o6a2b56e9g5ef83da195709bd5@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: meingbg <meingbg@gmail.com>
Cc: emacs-orgmode@gnu.org


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