From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <dominik@science.uva.nl>
Subject: Re: problems with table mode
Date: Sun, 20 Apr 2008 22:27:11 +0200
Message-ID: <07985476-0678-41F5-BB31-94E7F7E2010F@science.uva.nl>
References: <18277.1208719947@localhost>
Mime-Version: 1.0 (Apple Message framework v919.2)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Jng8C-0003iU-Uv
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 16:27:24 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Jng89-0003fg-Vc
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 16:27:24 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Jng89-0003fc-RZ
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 16:27:21 -0400
Received: from ug-out-1314.google.com ([66.249.92.173])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <carsten.dominik@gmail.com>) id 1Jng89-0007Cl-PI
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 16:27:22 -0400
Received: by ug-out-1314.google.com with SMTP id a2so587326ugf.48
	for <emacs-orgmode@gnu.org>; Sun, 20 Apr 2008 13:27:17 -0700 (PDT)
In-Reply-To: <18277.1208719947@localhost>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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@smtl.co.uk
Cc: org-mode mailing list <emacs-orgmode@gnu.org>

Hi Pete,

constructs like @III+1$2 are not allowed on the left side of a formula.
The left side must be either $N for a column, or @M$N for a field.
The error message stems from the face that the scanner for formulas
ignores the @III... spec and reads both formulas as $2=....

- Carsten

On Apr 20, 2008, at 9:32 PM, Pete Phillips wrote:

> I am having a problem with a table I use to calculate my annual leave
>
>
> | Basic Entitlement |         33 |
> | Carryover         |          5 |
> |-------------------+------------|
> | Date              | No of days |
> |-------------------+------------|
> | 25th April        |          1 |
> | 26th - 28th May   |          3 |
> |-------------------+------------|
> | Used              |          4 |
> | Remaining         |          4 |
> #+TBLFM: @III+1$2=vsum(@II+1$2..@III-1$2)::@III+2$2=@1$2+@2$2-@III+1
>
> The table gives me the correct calculation for 'Used' - i.e., the  
> number
> of days I have taken so far.
>
> However, the formula for the 'Remaining' row gives me the error
>
>  org-table-get-stored-formulas: Double definition `$2=' in TBLFM  
> line, please fix by hand
>
> I don't understand this - if @III+1$w works for the second column in  
> the
> Used row, why doesn't @III+2$2 work for the second column in the
> Remaining row ?
>
> Any help appreciated.
>
> Regards
> Pete
>
>
> _______________________________________________
> 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