Re: problems with table mode

From: Carsten Dominik <dominik@science.uva.nl>
To: pete@smtl.co.uk
Cc: org-mode mailing list <emacs-orgmode@gnu.org>
Subject: Re: problems with table mode
Date: Sun, 20 Apr 2008 22:27:11 +0200	[thread overview]
Message-ID: <07985476-0678-41F5-BB31-94E7F7E2010F@science.uva.nl> (raw)
In-Reply-To: <18277.1208719947@localhost>

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