* Table formula bug?
@ 2010-03-07 13:34 William Henney
2010-03-07 15:22 ` Carsten Dominik
0 siblings, 1 reply; 4+ messages in thread
From: William Henney @ 2010-03-07 13:34 UTC (permalink / raw)
To: emacs-org
Hi Carsten et al
Anyone have a clue what is going on here?
Cheers
Will
* Arctan2 bug
Activate the formula editor for the following table with =C-c '=, then
exit without changing anything. Note what happens to the arctan2
formula. For me, "arctan2" changes to "@2$20173232".
| x | y | arctan | arctan2 |
|---+---+--------+---------|
| 1 | 1 | 45 | 45. |
#+TBLFM: $3=arctan($1/$2)::$4=arctan2($1,$2)
** Versions
Org 6.34trans, Aquamacs 2.0preview4, Emacs 23.1.92.1
--
Dr William Henney, Centro de Radioastronomía y Astrofísica,
Universidad Nacional Autónoma de México, Campus Morelia
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: Table formula bug?
2010-03-07 13:34 Table formula bug? William Henney
@ 2010-03-07 15:22 ` Carsten Dominik
2010-03-07 17:31 ` William Henney
0 siblings, 1 reply; 4+ messages in thread
From: Carsten Dominik @ 2010-03-07 15:22 UTC (permalink / raw)
To: William Henney; +Cc: emacs-org
Hi William,
On Mar 7, 2010, at 2:34 PM, William Henney wrote:
> Hi Carsten et al
>
> Anyone have a clue what is going on here?
>
> Cheers
>
> Will
>
> * Arctan2 bug
> Activate the formula editor for the following table with =C-c '=, then
> exit without changing anything. Note what happens to the arctan2
> formula. For me, "arctan2" changes to "@2$20173232".
> | x | y | arctan | arctan2 |
> |---+---+--------+---------|
> | 1 | 1 | 45 | 45. |
> #+TBLFM: $3=arctan($1/$2)::$4=arctan2($1,$2)
Org does read arctan2 as a field reference like B4 or AB2 and
determinates that this is a row REALLY far to the right.
I have fixed this special case. Are there more functions in calc
which have names like this?
Thanks for the report!
- Carsten
>
> ** Versions
> Org 6.34trans, Aquamacs 2.0preview4, Emacs 23.1.92.1
>
>
>
>
> --
>
> Dr William Henney, Centro de Radioastronomía y Astrofísica,
> Universidad Nacional Autónoma de México, Campus Morelia
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- Carsten
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: Table formula bug?
2010-03-07 15:22 ` Carsten Dominik
@ 2010-03-07 17:31 ` William Henney
2010-03-08 8:06 ` Carsten Dominik
0 siblings, 1 reply; 4+ messages in thread
From: William Henney @ 2010-03-07 17:31 UTC (permalink / raw)
To: Carsten Dominik; +Cc: emacs-org
Hi Carsten,
On Sun, Mar 7, 2010 at 9:22 AM, Carsten Dominik
<carsten.dominik@gmail.com> wrote:
> Org does read arctan2 as a field reference like B4 or AB2 and determinates
> that this is a row REALLY far to the right.
>
> I have fixed this special case. Are there more functions in calc which have
> names like this?
I confirm that your fix works. Thanks for doing this so fast!
A quick search for digits in the "(calc) Function Index" info node
gives the following list:
arctan2, exp10, expm1, lnp1, log10, stir1, stir2
Here is a list of all the calc operators that I could find, some of
which might confuse your regexps:
!, !!, !!!, !=, %, &&, &&&, *, +, +/-, -, /, :, ::, :=, <, <=, =, ==,
=>, >, >=, ?, \, ^, _, |, ||, |||
I don't think it is necessary to allow all of these in table formulae
since many have synonyms. E.g., `x &&& y' can be written `pand(x, y)'
Cheers
Will
--
Dr William Henney, Centro de Radioastronomía y Astrofísica,
Universidad Nacional Autónoma de México, Campus Morelia
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: Table formula bug?
2010-03-07 17:31 ` William Henney
@ 2010-03-08 8:06 ` Carsten Dominik
0 siblings, 0 replies; 4+ messages in thread
From: Carsten Dominik @ 2010-03-08 8:06 UTC (permalink / raw)
To: William Henney; +Cc: emacs-org
Hi William,
On Mar 7, 2010, at 6:31 PM, William Henney wrote:
> Hi Carsten,
>
> On Sun, Mar 7, 2010 at 9:22 AM, Carsten Dominik
> <carsten.dominik@gmail.com> wrote:
>> Org does read arctan2 as a field reference like B4 or AB2 and
>> determinates
>> that this is a row REALLY far to the right.
>>
>> I have fixed this special case. Are there more functions in calc
>> which have
>> names like this?
>
> I confirm that your fix works. Thanks for doing this so fast!
>
> A quick search for digits in the "(calc) Function Index" info node
> gives the following list:
>
> arctan2, exp10, expm1, lnp1, log10, stir1, stir2
Thanks! I am catching aything now that has more than two letters,
which is probably OK (it assumes that org tables will never have more
than 676 rows....).
>
> Here is a list of all the calc operators that I could find, some of
> which might confuse your regexps:
>
> !, !!, !!!, !=, %, &&, &&&, *, +, +/-, -, /, :, ::, :=, <, <=, =, ==,
> =>, >, >=, ?, \, ^, _, |, ||, |||
>
> I don't think it is necessary to allow all of these in table formulae
> since many have synonyms. E.g., `x &&& y' can be written `pand(x, y)'
I think these are all OK. Only problem *might* be && and &&&, but
I think we should be fine here as well.
Thanks for your very complete answer!
- Carsten
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2010-03-08 8:06 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2010-03-07 13:34 Table formula bug? William Henney
2010-03-07 15:22 ` Carsten Dominik
2010-03-07 17:31 ` William Henney
2010-03-08 8:06 ` Carsten Dominik
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).