emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]