Re: [Orgmode] Spreadsheet bug?

[Carsten Dominik]

On Jul 24, 2009, at 11:20 AM, Stephan Schmitt wrote:

> Andreas Burtzlaff wrote:
> > 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
>
> > 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?
>
> Evaluating the field formulas before the column formulas is in  
> general a bad
> idea.  Results of the field formulas will always be overwritten by  
> the column
> formulas (if there is a conflict).

When recomputing a table,  Org evaluates field formulas first.
Then it does the column formulas, but never overwrites a field
that was filled with a field formula.

As mentioned elsewhere in this thread

> Here you need to evaluate the spreadsheet twice to yield the  
> intended result (I
> get a 5 in field @2$3).

Indeed, this is what is needed here.

- Carsten


>  From info:org:Updating the table:
>
> > `C-u C-u C-c *'
> > `C-u C-u C-c C-c'
> >     Iterate the table by recomputing it until no further changes  
> > occur.
> >     This may be necessary if some computed fields use the value of
> >     other fields that are computed later in the calculation sequence.
>
> hth,
>         Stephan
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode