[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