[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] problems with table mode

From: Carsten Dominik
Subject: Re: [Orgmode] problems with table mode
Date: Mon, 21 Apr 2008 08:13:12 +0200

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.


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:

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.


- Carsten

reply via email to

[Prev in Thread] Current Thread [Next in Thread]