Re: [Orgmode] Table formula bug?

2010-03-08 Thread Carsten Dominik

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.domi...@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



___
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


[Orgmode] Table formula bug?

2010-03-07 Thread William Henney
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


___
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


Re: [Orgmode] Table formula bug?

2010-03-07 Thread Carsten Dominik

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





___
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


Re: [Orgmode] Table formula bug?

2010-03-07 Thread William Henney
Hi Carsten,

On Sun, Mar 7, 2010 at 9:22 AM, Carsten Dominik
carsten.domi...@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


___
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