From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: problems with table mode Date: Mon, 21 Apr 2008 08:13:12 +0200 Message-ID: <28F7F848-17BF-462C-B89D-A9E110D1E0FB@science.uva.nl> References: <18277.1208719947@localhost> <07985476-0678-41F5-BB31-94E7F7E2010F@science.uva.nl> <18940.1208723747@localhost> Mime-Version: 1.0 (Apple Message framework v919.2) Content-Type: multipart/mixed; boundary="===============1378393275==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1JnpHC-00026p-Fn for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:13:18 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1JnpHB-00026Q-UH for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:13:18 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JnpHB-00026H-Qp for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:13:17 -0400 Received: from ug-out-1314.google.com ([66.249.92.168]) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1JnpHB-0006dY-5R for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:13:17 -0400 Received: by ug-out-1314.google.com with SMTP id a2so680950ugf.48 for ; Sun, 20 Apr 2008 23:13:16 -0700 (PDT) In-Reply-To: <18940.1208723747@localhost> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Pete Phillips Cc: org-mode mailing list --===============1378393275== Content-Type: multipart/alternative; boundary=Apple-Mail-10-670442341 --Apple-Mail-10-670442341 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit On Apr 20, 2008, at 10:35 PM, Pete Phillips wrote: > Evening Carsten >>>>>> "Carsten" == Carsten Dominik 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-. 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 --Apple-Mail-10-670442341 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable
On Apr 20, 2008, = at 10:35 PM, Pete Phillips wrote:
Evening = Carsten
"Carsten" =3D=3D 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=3D....


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=3Dvsum(@II+1$2..@III-1$2)::@7$2=3D@1$2+@2$2-@III+1

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.


HTH

- Carsten

= --Apple-Mail-10-670442341-- --===============1378393275== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============1378393275==--