On Apr 20, 2008, at 10:35 PM, Pete Phillips wrote:

> Evening Carsten
>>>>>> "Carsten" == Carsten Dominik <dominik@science.uva.nl> writes:
>
>    Carsten> constructs like @III+1$2 are not allowed on the left side
>    Carsten> of a formula.  The left side must be either $N for a
>    Carsten> column, or @M$N for a field.  The error message stems from
>    Carsten> the face that the scanner for formulas ignores the
>    Carsten> @III... spec and reads both formulas as $2=....
>
>
> Hmm - so how do I tell it which is the correct cell to put the
> calculation in ? I've clearly missed something vital here.
>
> Pete

Hi Phil,

the correct formula line would be

#+TBLFM: @6$2=vsum(@II+1$2..@III-1$2)::@7$2=@1$2+@2$2-@III+1

Take a look at Bastien's tutorial about table calculations in Org:

http://legito.net/worg/org-tutorials/org-spreadsheet-intro.php

In order to make sure that the formula stays correct, you need to
make sure that you add more lines to the table only with the
proper command M-S-<down>.  When using this command, the absolute
references in the formulas are modified.

I can see that a construct like you have been using would be
useful, because it would allow normal editing of the table and still
keep the correct results.  I have taken a note, maybe this
can be implemented at some point.


HTH

- Carsten