[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 11:04:53 +0200 |

On Thu, 23 Jul 2009 02:29:30 +0200
meingbg <address@hidden> wrote:
>* | a | b | c |*
>* |---+----+---|*
>* | a | 2 | 2 |*
>* | b | 3 | 7 |*
>* | c | -3 | 4 |*
>* | d | 5 | 9 |*
>* #+TBLFM: address@hidden::@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