On Jul 24, 2009, at 11:20 AM, Stephan Schmitt wrote:
Andreas Burtzlaff wrote:
On Thu, 23 Jul 2009 02:29:30 +0200 meingbg <mein...@gmail.com> wrote:
| a | b | c |
|---+----+---|
| a | 2 | 2 |
| b | 3 | 7 |
| c | -3 | 4 |
| d | 5 | 9 |
#+TBLFM: $3=...@-1::@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.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
