Re: [Orgmode] problems with table mode

[Carsten Dominik]

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

Evening Carsten

"Carsten" == Carsten Dominik <address@hidden> 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(@address@hidden)::@address@hidden@address@hidden

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