problems with table mode

problems with table mode

[Pete Phillips]

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

Re: problems with table mode

[Carsten Dominik]

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

Re: problems with table mode

[Carsten Dominik]

[-- Attachment #1.1: Type: text/plain, Size: 1336 bytes --]


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

> Evening Carsten
>>>>>> "Carsten" == 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=....
>
>
> 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-<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


[-- Attachment #1.2: Type: text/html, Size: 2443 bytes --]

[-- Attachment #2: Type: text/plain, Size: 204 bytes --]

_______________________________________________
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

Re: problems with table mode

[Pete Phillips]

Hi Carsten

>>>>> "Carsten" == Carsten Dominik <dominik@science.uva.nl> writes:

    Carsten> the correct formula line would be

    Carsten> #+TBLFM:
    Carsten> @6$2=vsum(@II+1$2..@III-1$2)::@7$2=@1$2+@2$2-@III+1

Well, this is what I have been using, but I've had to change it each
time I add a new date. Hence my search for something more generic.

    Carsten> In order to make sure that the formula stays correct, you
    Carsten> need to make sure that you add more lines to the table only
    Carsten> with the proper command M-S-<down>.  When using this
    Carsten> command, the absolute references in the formulas are
    Carsten> modified.

Ah - OK - this is clearly a solution - I have been using kill and yank
commands to add new entries.

    Carsten> I can see that a construct like you have been using would
    Carsten> be useful, because it would allow normal editing of the
    Carsten> table and still keep the correct results.  I have taken a
    Carsten> note, maybe this can be implemented at some point.

OK - not a major problem now I understand what the problem is.

Thanks
Pete