[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Spreadsheet bug?
From: |
Andreas Burtzlaff |
Subject: |
Re: [Orgmode] Spreadsheet bug? |
Date: |
Thu, 23 Jul 2009 12:39:37 +0200 |
On Thu, 23 Jul 2009 12:17:03 +0200
meingbg <address@hidden> 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