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