Actually, thinking more about this, I think that Tassilo is right.
Therefore, from now on, this condition will throw an error.
I would like to make this #ERROR in the table cell, but
this is not easy, so for the time being, it really stops
the evaluation with an error message.
Thanks, Tassilo, f
Hi Tassilo,
I can see that this could be confusing, and maybe it should throw an
error.
The use-ase fo this are running means as column formulas
that would be undefined for he first few rows in. Consider
the following table:
| i | nn | mean of last 3 |
|---++|
| 1 | 4
Carsten Dominik <[EMAIL PROTECTED]> writes:
Hi Carsten,
> @-1 references the row above the current. If that is a hline, if
> actually references the current line.
Yes, I see that, but I wonder if that's actually the right thing to do.
IMO defaulting to some cell/row/column which is not referenc
Hi Tassilo,
@-1 references the row above the current. If that is a hline, if
actually
references the current line.
So you are asking Org-mode to sum lines 2 - 6, which includes the
result line. So each time the calculation is done, it add the two
ones to the result from the previous cal
Hi all,
I have this table:
| header |
||
| 1 |
| 1 |
||
| 0 |
#+TBLFM: @4$1=vsum(@[EMAIL PROTECTED])
The cell containing 0 should sum up all values of the column's rows
above. But C-u C-c C-c gives 2, then 4, then 6, then 8...
Reading the docs I found out that @-