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
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
I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
If you clear column c completely, what is the output of the evaluation then?
The same. And so now I can't reproduce my original problem... that's
good, I guess.
A good solution is to use
$3=vsum(@-I$-1..$-1)
That works.
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
A good solution is to use
$3=vsum(@-I$-1..$-1)
as proposed in this thread:
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
That works for me, thanks!
Nevertheless:
If @2$3 is manually set to 2 in the table, then the formulas produce
the expected outcome. So, the problem
On Thu, 23 Jul 2009 12:17:03 +0200
meingbg mein...@gmail.com wrote:
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
I have a table like this one:
| a | b | c |
|---++---|
| a | 2 | 2 |
| b | 3 | 7 |
| c | -3 | 4 |
| d | 5 | 9 |
#+TBLFM: $3=...@-1::@2$3=$2
Now, I want the value in column c in every row to be the sum of column b so
far. I try to achieve this by writing a column formula for column $3 and