[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