* 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).