table formulas revisited

table formulas revisited

[Eddward DeVilla]

Hi all,

    This is something I thought I had working before.  In anycase,
anytime I use a range in a table, I cannot get it to evaluate.  It
dies before even reaching the formula debugger with "Wrong number of
arguments: #<subr mapconcat>, 2".  This is org 5.03 and I've tried it
on emacs 21.1.1 and 21.3.50.1.
    What's really weird is that I think this was working eariler this
week on the same version of org and emacs.  Can anyone else try
dropping this table in an org buffer and hitting C-cC-c on the TBLFM
line to confirm if it's just me?

Thanks,
Edd

* wealth management
 |--------------------------+---------+---------|
 | item                     |  amount | balance |
 |--------------------------+---------+---------|
 | paid                     |   50.00 |   50.00 |
 | baby's new pair of shoes |  -25.00 |   25.00 |
 | chips                    |   -2.50 |   22.50 |
 | my birthday!             |  100.00 |  122.50 |
 | speeding fine :(         | -200.00 |  -77.50 |
 |--------------------------+---------+---------|
#+TBLFM: $3='(apply '+ '(@-I$-1..$-1));N%.2f

Re: table formulas revisited

[Eddward DeVilla]

    I must have been asleep at the wheel when 5.04 came out.  Anyhow,
that doesn't work either.

Edd

On 7/27/07, Eddward DeVilla <eddward@gmail.com> wrote:
> Hi all,
>
>     This is something I thought I had working before.  In anycase,
> anytime I use a range in a table, I cannot get it to evaluate.  It
> dies before even reaching the formula debugger with "Wrong number of
> arguments: #<subr mapconcat>, 2".  This is org 5.03 and I've tried it
> on emacs 21.1.1 and 21.3.50.1.
>     What's really weird is that I think this was working eariler this
> week on the same version of org and emacs.  Can anyone else try
> dropping this table in an org buffer and hitting C-cC-c on the TBLFM
> line to confirm if it's just me?
>
> Thanks,
> Edd
>
> * wealth management
>  |--------------------------+---------+---------|
>  | item                     |  amount | balance |
>  |--------------------------+---------+---------|
>  | paid                     |   50.00 |   50.00 |
>  | baby's new pair of shoes |  -25.00 |   25.00 |
>  | chips                    |   -2.50 |   22.50 |
>  | my birthday!             |  100.00 |  122.50 |
>  | speeding fine :(         | -200.00 |  -77.50 |
>  |--------------------------+---------+---------|
> #+TBLFM: $3='(apply '+ '(@-I$-1..$-1));N%.2f
>

Re: table formulas revisited

[Eddward DeVilla]

I think I fixed my problem, but I was wondering if someone with some
more elisp org-code knowledge could check this for me.  The 5.04 diff
is

8876a8877
>        elements

It looks like an argument to the first mapconcat was missing in
org-table-make-reference.

Edd

On 7/27/07, Eddward DeVilla <eddward@gmail.com> wrote:
>     I must have been asleep at the wheel when 5.04 came out.  Anyhow,
> that doesn't work either.
>
> Edd
>
> On 7/27/07, Eddward DeVilla <eddward@gmail.com> wrote:
> > Hi all,
> >
> >     This is something I thought I had working before.  In anycase,
> > anytime I use a range in a table, I cannot get it to evaluate.  It
> > dies before even reaching the formula debugger with "Wrong number of
> > arguments: #<subr mapconcat>, 2".  This is org 5.03 and I've tried it
> > on emacs 21.1.1 and 21.3.50.1.
> >     What's really weird is that I think this was working eariler this
> > week on the same version of org and emacs.  Can anyone else try
> > dropping this table in an org buffer and hitting C-cC-c on the TBLFM
> > line to confirm if it's just me?
> >
> > Thanks,
> > Edd
> >
> > * wealth management
> >  |--------------------------+---------+---------|
> >  | item                     |  amount | balance |
> >  |--------------------------+---------+---------|
> >  | paid                     |   50.00 |   50.00 |
> >  | baby's new pair of shoes |  -25.00 |   25.00 |
> >  | chips                    |   -2.50 |   22.50 |
> >  | my birthday!             |  100.00 |  122.50 |
> >  | speeding fine :(         | -200.00 |  -77.50 |
> >  |--------------------------+---------+---------|
> > #+TBLFM: $3='(apply '+ '(@-I$-1..$-1));N%.2f
> >
>

Re: table formulas revisited

[Carsten Dominik]

This is a bug.  Fixed for te next version, thanks.

- Carsten

On Jul 27, 2007, at 22:39, Eddward DeVilla wrote:

>  |--------------------------+---------+---------|
>  | item                     |  amount | balance |
>  |--------------------------+---------+---------|
>  | paid                     |   50.00 |   50.00 |
>  | baby's new pair of shoes |  -25.00 |   25.00 |
>  | chips                    |   -2.50 |   22.50 |
>  | my birthday!             |  100.00 |  122.50 |
>  | speeding fine :(         | -200.00 |  -77.50 |
>  |--------------------------+---------+---------|
> #+TBLFM: $3='(apply '+ '(@-I$-1..$-1));N%.2f
>
>

--
Carsten Dominik
Sterrenkundig Instituut "Anton Pannekoek"
Universiteit van Amsterdam
Kruislaan 403
NL-1098SJ Amsterdam
phone: +31 20 525 7477