* [bug?] Copy content from one to another table changes the content @ 2013-07-13 20:47 Torsten Wagner 2013-07-14 3:29 ` Nick Dokos 0 siblings, 1 reply; 7+ messages in thread From: Torsten Wagner @ 2013-07-13 20:47 UTC (permalink / raw) To: Org Mode Mailing List [-- Attachment #1: Type: text/plain, Size: 411 bytes --] Hi, I just notice a strange behaviour within tables. I want to copy a column of one table into another... using $1=remote(prf94120_orig, @@#$6). The original content consist of names in the form "lastname,firstnames". However, executing the above formular I receive "lastname + firstnames i" I have totally no clue what is the reason for that.... a bug?! Happens within Org-mode version 8.0.3 Thanks Torsten [-- Attachment #2: Type: text/html, Size: 521 bytes --] ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-13 20:47 [bug?] Copy content from one to another table changes the content Torsten Wagner @ 2013-07-14 3:29 ` Nick Dokos 2013-07-15 9:43 ` Torsten Wagner 0 siblings, 1 reply; 7+ messages in thread From: Nick Dokos @ 2013-07-14 3:29 UTC (permalink / raw) To: emacs-orgmode Torsten Wagner <torsten.wagner@gmail.com> writes: > I just notice a strange behaviour within tables. I want to copy a > column of one table into another... using $1=remote(prf94120_orig, > @@#$6). The original content consist of names in the form > "lastname,firstnames". However, executing the above formular I receive > "lastname + firstnames i" > > I have totally no clue what is the reason for that.... a bug?! > Happens within Org-mode version 8.0.3 > I tried it (on a single table too - no remote) and I get the same behavior. I can't pretend to understand how anything in org-table.el works, but I think this is a clue: on line 2678, org-table-make-reference is called. If I call it by hand like this (org-table-make-reference "a, b" nil nil nil) --> "(a, b)" Then on line 2706, calc-eval is called. If I call it by hand on the value above (calc-eval "(a, b)") --> "a + b i" I think it's trying to do arithmetic on complex numbers... -- Nick ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-14 3:29 ` Nick Dokos @ 2013-07-15 9:43 ` Torsten Wagner 2013-07-15 13:27 ` Torsten Wagner 0 siblings, 1 reply; 7+ messages in thread From: Torsten Wagner @ 2013-07-15 9:43 UTC (permalink / raw) To: Nick Dokos; +Cc: Org Mode Mailing List [-- Attachment #1: Type: text/plain, Size: 1605 bytes --] Hi Nick, very good observation. Just wonder are we the first who observe this problem?! It seems org-table-make-reference and calc-eval have some sort of an different idea of the data content. Yes calc use that notation to deal with imaginary numbers. Funny coincidence, the students in that list just struggle with exactly those imaginary numbers and now there names became a imaginary number itself... ;) Thanks for the tip, I will see if some search and replace helps me to create a intermediate solution. Thanks Torsten On 14 July 2013 05:29, Nick Dokos <ndokos@gmail.com> wrote: > Torsten Wagner <torsten.wagner@gmail.com> writes: > > > I just notice a strange behaviour within tables. I want to copy a > > column of one table into another... using $1=remote(prf94120_orig, > > @@#$6). The original content consist of names in the form > > "lastname,firstnames". However, executing the above formular I receive > > "lastname + firstnames i" > > > > I have totally no clue what is the reason for that.... a bug?! > > Happens within Org-mode version 8.0.3 > > > > I tried it (on a single table too - no remote) and I get the same > behavior. I can't pretend to understand how anything in org-table.el > works, but I think this is a clue: on line 2678, > org-table-make-reference is called. If I call it by hand like this > > (org-table-make-reference "a, b" nil nil nil) --> "(a, b)" > > Then on line 2706, calc-eval is called. If I call it by hand on the > value above > > (calc-eval "(a, b)") --> "a + b i" > > I think it's trying to do arithmetic on complex numbers... > -- > Nick > > > [-- Attachment #2: Type: text/html, Size: 2351 bytes --] ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-15 9:43 ` Torsten Wagner @ 2013-07-15 13:27 ` Torsten Wagner 2013-07-15 13:36 ` Nick Dokos 0 siblings, 1 reply; 7+ messages in thread From: Torsten Wagner @ 2013-07-15 13:27 UTC (permalink / raw) To: Nick Dokos; +Cc: Org Mode Mailing List [-- Attachment #1: Type: text/plain, Size: 2216 bytes --] Hi again, I can confirm that behaviour for org-mode < 8.0 (tested on 7.9.3f) if that matter. Furtermore, I tested a lot of alternatives. "lastname, firstname" lastname, firstname lastname; firstname etc. It seems, they all get somehow evaluated by calc, which ends up in funny different results. I do not understand what was the intention of letting the code be parsed by calc but it seems to cause trouble. Will test to comment how to get around it Thanks Torsten On 15 July 2013 11:43, Torsten Wagner <torsten.wagner@gmail.com> wrote: > Hi Nick, > > very good observation. Just wonder are we the first who observe this > problem?! > It seems org-table-make-reference and calc-eval have some sort of an > different idea of the data content. > Yes calc use that notation to deal with imaginary numbers. Funny > coincidence, the students in that list just struggle with exactly those > imaginary numbers and now there names became a imaginary number itself... ;) > > Thanks for the tip, I will see if some search and replace helps me to > create a intermediate solution. > > Thanks > > Torsten > > > > On 14 July 2013 05:29, Nick Dokos <ndokos@gmail.com> wrote: > >> Torsten Wagner <torsten.wagner@gmail.com> writes: >> >> > I just notice a strange behaviour within tables. I want to copy a >> > column of one table into another... using $1=remote(prf94120_orig, >> > @@#$6). The original content consist of names in the form >> > "lastname,firstnames". However, executing the above formular I receive >> > "lastname + firstnames i" >> > >> > I have totally no clue what is the reason for that.... a bug?! >> > Happens within Org-mode version 8.0.3 >> > >> >> I tried it (on a single table too - no remote) and I get the same >> behavior. I can't pretend to understand how anything in org-table.el >> works, but I think this is a clue: on line 2678, >> org-table-make-reference is called. If I call it by hand like this >> >> (org-table-make-reference "a, b" nil nil nil) --> "(a, b)" >> >> Then on line 2706, calc-eval is called. If I call it by hand on the >> value above >> >> (calc-eval "(a, b)") --> "a + b i" >> >> I think it's trying to do arithmetic on complex numbers... >> -- >> Nick >> >> >> > [-- Attachment #2: Type: text/html, Size: 3616 bytes --] ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-15 13:27 ` Torsten Wagner @ 2013-07-15 13:36 ` Nick Dokos 2013-07-16 10:24 ` Torsten Wagner 0 siblings, 1 reply; 7+ messages in thread From: Nick Dokos @ 2013-07-15 13:36 UTC (permalink / raw) To: emacs-orgmode Torsten Wagner <torsten.wagner@gmail.com> writes: > > I can confirm that behaviour for org-mode < 8.0 (tested on 7.9.3f) if that matter. > Furtermore, I tested a lot of alternatives. > "lastname, firstname" > lastname, firstname > lastname; firstname > etc. > It seems, they all get somehow evaluated by calc, which ends up in funny different results. > I do not understand what was the intention of letting the code be parsed by calc but it seems to cause trouble. > As I said, I don't know much about the implementation of tables, but I think passing every entry in the table through calc is by design. And it does not need to cause trouble either: (calc-eval "abc, def") ---> "abc, def" So trying to selectively *not* pass a cell through calc seems to be the wrong way to go. > Will test to comment how to get around it > > Thanks > Torsten > > On 15 July 2013 11:43, Torsten Wagner <torsten.wagner@gmail.com> wrote: > > Hi Nick, > > very good observation. Just wonder are we the first who observe this problem?! > It seems org-table-make-reference and calc-eval have some sort of an different idea of the data content. > Yes calc use that notation to deal with imaginary numbers. Funny coincidence, the students in that list just struggle with exactly those imaginary numbers and now there names > became a imaginary number itself... ;) > > Thanks for the tip, I will see if some search and replace helps me to create a intermediate solution. > > Thanks > > Torsten > > On 14 July 2013 05:29, Nick Dokos <ndokos@gmail.com> wrote: > > Torsten Wagner <torsten.wagner@gmail.com> writes: > > > I just notice a strange behaviour within tables. I want to copy a > > column of one table into another... using $1=remote(prf94120_orig, > > @@#$6). The original content consist of names in the form > > "lastname,firstnames". However, executing the above formular I receive > > "lastname + firstnames i" > > > > I have totally no clue what is the reason for that.... a bug?! > > Happens within Org-mode version 8.0.3 > > > > I tried it (on a single table too - no remote) and I get the same > behavior. I can't pretend to understand how anything in org-table.el > works, but I think this is a clue: on line 2678, > org-table-make-reference is called. If I call it by hand like this > > (org-table-make-reference "a, b" nil nil nil) --> "(a, b)" > > Then on line 2706, calc-eval is called. If I call it by hand on the > value above > > (calc-eval "(a, b)") --> "a + b i" > > I think it's trying to do arithmetic on complex numbers... > -- > Nick > -- Nick ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-15 13:36 ` Nick Dokos @ 2013-07-16 10:24 ` Torsten Wagner 2013-07-16 14:09 ` Michael Brand 0 siblings, 1 reply; 7+ messages in thread From: Torsten Wagner @ 2013-07-16 10:24 UTC (permalink / raw) To: Nick Dokos; +Cc: Org Mode Mailing List [-- Attachment #1: Type: text/plain, Size: 4419 bytes --] Hi again, I think I got a bit more of an idea what is going wrong thanks to Nick. I use $1 = remote(prf94120_orig, @@#$6) which reads copy from table prf94120_orig row (@) of the current to be processed field (@#) column ($) 6 into column ($) 1. The org-mode manual refers to @# as operator for formulas and hence I believe the result will be parsed by calc to get a meaningful output. That is ok for simple strings without space or comma separators, since they remain strings. However, a string like "text,text" will be send to calc as ("text","text") which is the calc notation for imaginary numbers. Either, I should use a different way to copy the column or this could be considered as a bug?! Actually, I still do not understand the need to let calc parse that a field-content. If I want to do math, I am not suppose to express this explicit by my formula? Instead of having a single field content of "1 + 2" evaluated to be "3" by remote copy, I would expect to do something like remote(NAME, REF) + remote(NAME, REF) for calculating the sum of two remote fields or in case I really have a complete expression in a single field, I would expect to do something like (calc remote(NAME, REF)) explicit to get it parsed by calc and placing the result in the new table?! Somehow, I miss something. Would be glad if someone could explain to me the reason for the original behaviour. Thanks Torsten On 15 July 2013 15:36, Nick Dokos <ndokos@gmail.com> wrote: > Torsten Wagner <torsten.wagner@gmail.com> writes: > > > > > I can confirm that behaviour for org-mode < 8.0 (tested on 7.9.3f) if > that matter. > > Furtermore, I tested a lot of alternatives. > > "lastname, firstname" > > lastname, firstname > > lastname; firstname > > etc. > > It seems, they all get somehow evaluated by calc, which ends up in funny > different results. > > I do not understand what was the intention of letting the code be parsed > by calc but it seems to cause trouble. > > > > As I said, I don't know much about the implementation of tables, but I > think passing every entry in the table through calc is by design. And it > does not need to cause trouble either: > > (calc-eval "abc, def") ---> "abc, def" > > So trying to selectively *not* pass a cell through calc seems to be the > wrong way to go. > > > Will test to comment how to get around it > > > > Thanks > > Torsten > > > > On 15 July 2013 11:43, Torsten Wagner <torsten.wagner@gmail.com> wrote: > > > > Hi Nick, > > > > very good observation. Just wonder are we the first who observe this > problem?! > > It seems org-table-make-reference and calc-eval have some sort of an > different idea of the data content. > > Yes calc use that notation to deal with imaginary numbers. Funny > coincidence, the students in that list just struggle with exactly those > imaginary numbers and now there names > > became a imaginary number itself... ;) > > > > Thanks for the tip, I will see if some search and replace helps me > to create a intermediate solution. > > > > Thanks > > > > Torsten > > > > On 14 July 2013 05:29, Nick Dokos <ndokos@gmail.com> wrote: > > > > Torsten Wagner <torsten.wagner@gmail.com> writes: > > > > > I just notice a strange behaviour within tables. I want to > copy a > > > column of one table into another... using > $1=remote(prf94120_orig, > > > @@#$6). The original content consist of names in the form > > > "lastname,firstnames". However, executing the above formular I > receive > > > "lastname + firstnames i" > > > > > > I have totally no clue what is the reason for that.... a bug?! > > > Happens within Org-mode version 8.0.3 > > > > > > > I tried it (on a single table too - no remote) and I get the same > > behavior. I can't pretend to understand how anything in > org-table.el > > works, but I think this is a clue: on line 2678, > > org-table-make-reference is called. If I call it by hand like > this > > > > (org-table-make-reference "a, b" nil nil nil) --> "(a, b)" > > > > Then on line 2706, calc-eval is called. If I call it by hand on > the > > value above > > > > (calc-eval "(a, b)") --> "a + b i" > > > > I think it's trying to do arithmetic on complex numbers... > > -- > > Nick > > > > -- > Nick > > > [-- Attachment #2: Type: text/html, Size: 5925 bytes --] ^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: [bug?] Copy content from one to another table changes the content 2013-07-16 10:24 ` Torsten Wagner @ 2013-07-16 14:09 ` Michael Brand 0 siblings, 0 replies; 7+ messages in thread From: Michael Brand @ 2013-07-16 14:09 UTC (permalink / raw) To: Torsten Wagner; +Cc: Org Mode Mailing List Hi Torsten On Tue, Jul 16, 2013 at 12:24 PM, Torsten Wagner <torsten.wagner@gmail.com> wrote: > Either, I should use a different way to copy the column or this could be > considered as a bug?! Some time ago I did some experiments about just copying a field that I put into the ERT function test-org-table/copy-field in testing/lisp/test-org-table.el for documentation. The Calc variants there are more for fun than useful. The Lisp variant: #+TBLFM: $1 = '(identity remote(prf94120_orig, @@#$6)) test-org-table.el on the Web: http://orgmode.org/w/org-mode.git?p=org-mode.git;a=blob;f=testing/lisp/test-org-table.el Michael ^ permalink raw reply [flat|nested] 7+ messages in thread
end of thread, other threads:[~2013-07-16 14:14 UTC | newest] Thread overview: 7+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2013-07-13 20:47 [bug?] Copy content from one to another table changes the content Torsten Wagner 2013-07-14 3:29 ` Nick Dokos 2013-07-15 9:43 ` Torsten Wagner 2013-07-15 13:27 ` Torsten Wagner 2013-07-15 13:36 ` Nick Dokos 2013-07-16 10:24 ` Torsten Wagner 2013-07-16 14:09 ` Michael Brand
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).