Re: [Orgmode] Spreadsheet question

2008-12-05 Thread Carsten Dominik
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

Re: [Orgmode] Spreadsheet question

2008-12-05 Thread Carsten Dominik
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

Re: [Orgmode] Spreadsheet question

2008-12-04 Thread Tassilo Horn
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

Re: [Orgmode] Spreadsheet question

2008-12-04 Thread Carsten Dominik
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

[Orgmode] Spreadsheet question

2008-12-03 Thread Tassilo Horn
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 @-