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 12:39:37 +0200
Message-ID: <20090723123937.c8330ef4.andy13@gmx.net>
References: <c91ecc400907230317t7b46a743seb9d3134a8bf7f9f@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 1MTvi0-0004e1-Fz
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:39:32 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MTvhv-0004dQ-Qy
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:39:32 -0400
Received: from [199.232.76.173] (port=40310 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MTvhv-0004dN-HC
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:39:27 -0400
Received: from mail.gmx.net ([213.165.64.20]:37548)
	by monty-python.gnu.org with smtp (Exim 4.60)
	(envelope-from <andy13@gmx.net>) id 1MTvhu-00037O-O8
	for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:39:27 -0400
In-Reply-To: <c91ecc400907230317t7b46a743seb9d3134a8bf7f9f@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 12:17:03 +0200
meingbg <meingbg@gmail.com> wrote:

> > 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.
> 
> If that was the case, wouldn't @3$3 sum up to 3+0=3? Now it shows 7.

I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
If you clear column c completely, what is the output of the evaluation then?
I get:

| a |  b | c |
|---+----+---|
| a |  2 | 2 |
| b |  3 | 3 |
| c | -3 | 0 |
| d |  5 | 5 |

Andy