Re: [Orgmode] Spreadsheet question

[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 |           4.00 |
| 2 |  7 |           5.50 |
| 3 |  2 |           4.33 |
| 4 |  4 |           4.33 |
| 5 |  5 |           3.67 |
| 6 |  7 |           5.33 |
| 7 |  9 |           7.00 |
| 8 | 22 |          12.67 |
#+TBLFM: $3=vmean(address@hidden);%.2f

I am not sure how common this use is and who would
be hurt by turning this behavior into an error.

- Carsten

On Dec 4, 2008, at 11:49 AM, Tassilo Horn wrote:

> Carsten Dominik <address@hidden> 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 referenced  
> correctly
> might obscure wrong formulas.
>
> For example, in my case the first calculation gave 2 which is correct
> and only the second recalculation shows me that the forumla is wrong.
> So I'd prefer an #ERROR if a reference doesn't exist.
>
> Bye,
> Tassilo