From mboxrd@z Thu Jan 1 00:00:00 1970 From: Lester Longley Subject: Bug: assignment to named column - not working as expected [9.3.6 (9.3.6-elpa @ ~/.emacs.d/elpa/org-9.3.6/)] Date: Sat, 29 Feb 2020 09:39:40 -0500 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000390ece059fb7edd8" Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:43521) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1j83HZ-0007K6-Ek for emacs-orgmode@gnu.org; Sat, 29 Feb 2020 09:40:00 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1j83HW-0002c8-Mm for emacs-orgmode@gnu.org; Sat, 29 Feb 2020 09:39:56 -0500 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]:38077) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1j83HW-0002bz-Bh for emacs-orgmode@gnu.org; Sat, 29 Feb 2020 09:39:54 -0500 Received: by mail-qt1-x843.google.com with SMTP id e20so4300400qto.5 for ; Sat, 29 Feb 2020 06:39:53 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org --000000000000390ece059fb7edd8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, I'm trying to use named fields. This works: | ! | col2 | col3 | | # | abc | abc | #+TBLFM: $3 =3D $col2 However, assignment to named field "$col3": | ! | col2 | col3 | | # | abc | | #+TBLFM: $col3 =3D $col2 ... results in error "Unknown field: col3". I was expecting assignment to the named column to work, as per https://orgmode.org/manual/Advanced-features.html =E2=80=98!=E2=80=99 The fields in this line define names for the columns, so that you may refer to a column as =E2=80=98$Tot=E2=80=99 instead of =E2=80=98$6=E2=80=99. =E2=80=98^=E2=80=99 This row defines names for the fields *above* the row. With such a definition, any formula in the table may use =E2=80=98$m1=E2=80=99 to refer= to the value =E2=80=9810=E2=80=99. Also, if you assign a formula to a names field, it is stored as =E2=80=98$n= ame =3D ... =E2=80=99. However, the documentation doesn't specifically indicate that assignment to "$name" should work w/ "!"--it's mentioned only w/ "^" (and works fine for this case)--so possibly what I'm trying simply isn't supported (i.e., not a bug). Please pardon if that's not right expectation. Thank you for your help. Regards, Lester Emacs : GNU Emacs 25.1.1 (x86_64-pc-linux-gnu, GTK+ Version 3.22.11) of 2017-09-15, modified by Debian Package: Org mode version 9.3.6 (9.3.6-elpa @ ~/.emacs.d/elpa/org-9.3.6/) current state: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D (setq org-tab-first-hook '(org-babel-hide-result-toggle-maybe org-babel-header-arg-expand) org-speed-command-hook '(org-speed-command-activate org-babel-speed-command-activate) org-occur-hook '(org-first-headline-recenter) org-metaup-hook '(org-babel-load-in-session-maybe) org-confirm-shell-link-function 'yes-or-no-p org-src-mode-hook '(org-src-babel-configure-edit-buffer org-src-mode-configure-edit-buffer) org-agenda-before-write-hook '(org-agenda-add-entry-text) org-babel-pre-tangle-hook '(save-buffer) org-mode-hook '((closure (org--rds reftex-docstruct-symbol org-element-greater-elements org-clock-history org-agenda-current-date org-with-time org-defdecode org-def org-read-date-inactive org-ans2 org-ans1 org-columns-current-fmt-compiled org-clock-current-task org-clock-effort org-agenda-skip-function org-agenda-skip-comment-trees org-agenda-archives-mode org-end-time-was-given org-time-was-given org-log-note-extra org-log-note-purpose org-log-post-message org-last-inserted-timestamp org-last-changed-timestamp org-entry-property-inherited-from org-blocked-by-checkboxes org-state org-agenda-headline-snapshot-before-repeat org-capture-last-stored-marker org-agenda-start-on-weekday org-agenda-buffer-tmp-name org-priority-regexp buffer-face-mode-face org-tbl-menu org-org-menu org-struct-menu org-entities org-last-state org-id-track-globally org-clock-start-time texmathp-why remember-data-file org-agenda-tags-todo-honor-ignore-options iswitchb-temp-buflist calc-embedded-open-mode calc-embedded-open-formula calc-embedded-close-formula align-mode-rules-list org-emphasis-alist org-emphasis-regexp-components org-export-registered-backends org-modules org-babel-load-languages org-indent-indentation-per-level org-element-paragraph-separate ffap-url-regexp org-inlinetask-min-level t) nil (add-hook (quote change-major-mode-hook) (quote org-show-all) (quote append) (quote local)) ) (closure (org-src-window-setup *this* org-babel-confirm-evaluate-answer-no org-src-preserve-indentation org-src-lang-modes org-edit-src-content-indentation org-babel-library-of-babel t) nil (add-hook (quote change-major-mode-hook) (quote org-babel-show-result-all) (quote append) (quote local)) ) org-babel-result-hide-spec org-babel-hide-all-hashes) org-bibtex-headline-format-function '(closure (org-id-locations org-agenda-search-view-always-boolean org-agenda-overriding-header t) (entry) (cdr (assq :title entry))) org-archive-hook '(org-attach-archive-delete-maybe) org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-show-empty-lines org-optimize-window-after-visibility-change) org-link-shell-confirm-function 'yes-or-no-p org-link-elisp-confirm-function 'yes-or-no-p org-confirm-elisp-link-function 'yes-or-no-p org-metadown-hook '(org-babel-pop-to-session-maybe) org-link-parameters '(("attachment" :follow org-attach-open-link :export org-attach-export-link :complete org-attach-complete-link) ("id" :follow org-id-open) ("eww" :follow eww :store org-eww-store-link) ("rmail" :follow org-rmail-open :store org-rmail-store-link) ("mhe" :follow org-mhe-open :store org-mhe-store-link) ("irc" :follow org-irc-visit :store org-irc-store-link :export org-irc-export) ("info" :follow org-info-open :export org-info-export :store org-info-store-link) ("gnus" :follow org-gnus-open :store org-gnus-store-link) ("docview" :follow org-docview-open :export org-docview-export :store org-docview-store-link) ("bibtex" :follow org-bibtex-open :store org-bibtex-store-link) ("bbdb" :follow org-bbdb-open :export org-bbdb-export :complete org-bbdb-complete-link :store org-bbdb-store-link) ("w3m" :store org-w3m-store-link) ("file+sys") ("file+emacs") ("shell" :follow org-link--open-shell) ("news" :follow (closure ((scheme . "news") (--dolist-tail--) org-ts-regexp org-time-stamp-formats org-src-source-file-name org-outline-regexp-bol org-inhibit-startup org-id-link-to-org-use-id org-highlight-links org-comment-string org-agenda-buffer-name clean-buffer-list-kill-buffer-names t) (url) (browse-url (concat scheme ":" url))) ) ("mailto" :follow (closure ((scheme . "mailto") (--dolist-tail--) org-ts-regexp org-time-stamp-formats org-src-source-file-name org-outline-regexp-bol org-inhibit-startup org-id-link-to-org-use-id org-highlight-links org-comment-string org-agenda-buffer-name clean-buffer-list-kill-buffer-names t) (url) (browse-url (concat scheme ":" url))) ) ("https" :follow (closure ((scheme . "https") (--dolist-tail--) org-ts-regexp org-time-stamp-formats org-src-source-file-name org-outline-regexp-bol org-inhibit-startup org-id-link-to-org-use-id org-highlight-links org-comment-string org-agenda-buffer-name clean-buffer-list-kill-buffer-names t) (url) (browse-url (concat scheme ":" url))) ) ("http" :follow (closure ((scheme . "http") (--dolist-tail--) org-ts-regexp org-time-stamp-formats org-src-source-file-name org-outline-regexp-bol org-inhibit-startup org-id-link-to-org-use-id org-highlight-links org-comment-string org-agenda-buffer-name clean-buffer-list-kill-buffer-names t) (url) (browse-url (concat scheme ":" url))) ) ("ftp" :follow (closure ((scheme . "ftp") (--dolist-tail--) org-ts-regexp org-time-stamp-formats org-src-source-file-name org-outline-regexp-bol org-inhibit-startup org-id-link-to-org-use-id org-highlight-links org-comment-string org-agenda-buffer-name clean-buffer-list-kill-buffer-names t) (url) (browse-url (concat scheme ":" url))) ) ("help" :follow org-link--open-help) ("file" :complete org-link-complete-file) ("elisp" :follow org-link--open-elisp) ("doi" :follow org-link--open-doi)) org-clock-out-hook '(org-clock-remove-empty-clock-drawer) ) --000000000000390ece059fb7edd8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

I'm trying to use named fiel= ds.

This works:

| ! | col= 2 | col3 |
| # | abc =C2=A0| abc =C2=A0|
#+TBLFM: $3 =3D $col2
However, assignment to named field "$col3":

| ! | col2 | = col3 |
| # | abc =C2=A0|=C2=A0 |
#+TBLFM: $col3 =3D $col2

... = results in error "Unknown field: col3".

= I was expecting assignment to the named column to work, as per=C2=A0https://orgmode.org/= manual/Advanced-features.html

=E2=80=98!=E2=80=99

The fields in this line define names for the columns, so that you may= refer to a column as =E2=80=98$Tot=E2=80=99 instead of =E2=80= =98$6=E2=80=99.

=E2=80=98^=E2=80=99

This row defines names for the fields=C2=A0above=C2=A0the ro= w. With such a definition, any formula in the table may use =E2=80=98= $m1=E2=80=99 to refer to the value =E2=80=9810=E2=80=99= . Also, if you assign a formula to a names field, it is stored as =E2=80=98= $name =3D ...=E2=80=99.

H= owever, the documentation doesn't specifically indicate that assignment= to "$name" should work w/ "!"--it's mentioned only= w/ "^" (and works fine for this case)--so possibly what I'm = trying simply isn't supported (i.e., not a bug).=C2=A0 Please pardon if= that's not right expectation.

Thank you for=C2=A0your help.

Regards,<= /div>
Lester

Emacs =C2=A0: GNU Emacs 25.1.1 (x86_64-pc-linux-gnu= , GTK+ Version 3.22.11)
=C2=A0of 2017-09-15, modified by Debian
Packa= ge: Org mode version 9.3.6 (9.3.6-elpa @ ~/.emacs.d/elpa/org-9.3.6/)
current state:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
(setq
= =C2=A0org-tab-first-hook '(org-babel-hide-result-toggle-maybe
=C2= =A0 =C2=A0 =C2=A0org-babel-header-arg-expand)
=C2=A0org-speed-command-ho= ok '(org-speed-command-activate
=C2=A0org-babel-speed-command-ac= tivate)
=C2=A0org-occur-hook '(org-first-headline-recenter)
=C2= =A0org-metaup-hook '(org-babel-load-in-session-maybe)
=C2=A0org-conf= irm-shell-link-function 'yes-or-no-p
=C2=A0org-src-mode-hook '(o= rg-src-babel-configure-edit-buffer
=C2=A0 =C2=A0 org-src-mode-configu= re-edit-buffer)
=C2=A0org-agenda-before-write-hook '(org-agenda-add-= entry-text)
=C2=A0org-babel-pre-tangle-hook '(save-buffer)
=C2=A0= org-mode-hook '((closure
=C2=A0(org--rds reftex-docstruct-symbol<= br> =C2=A0 org-element-greater-elements org-clock-history
=C2=A0 or= g-agenda-current-date org-with-time org-defdecode org-def
=C2=A0 org-= read-date-inactive org-ans2 org-ans1
=C2=A0 org-columns-current-fmt-c= ompiled org-clock-current-task
=C2=A0 org-clock-effort org-agenda-ski= p-function
=C2=A0 org-agenda-skip-comment-trees org-agenda-archives-m= ode
=C2=A0 org-end-time-was-given org-time-was-given
=C2=A0 org= -log-note-extra org-log-note-purpose
=C2=A0 org-log-post-message org-= last-inserted-timestamp
=C2=A0 org-last-changed-timestamp
=C2= =A0 org-entry-property-inherited-from org-blocked-by-checkboxes
=C2= =A0 org-state org-agenda-headline-snapshot-before-repeat
=C2=A0 org-c= apture-last-stored-marker org-agenda-start-on-weekday
=C2=A0 org-agen= da-buffer-tmp-name org-priority-regexp
=C2=A0 buffer-face-mode-face o= rg-tbl-menu org-org-menu
=C2=A0 org-struct-menu org-entities org-last= -state
=C2=A0 org-id-track-globally org-clock-start-time texmathp-why=
=C2=A0 remember-data-file
=C2=A0 org-agenda-tags-todo-honor-ig= nore-options
=C2=A0 iswitchb-temp-buflist calc-embedded-open-mode
= =C2=A0 calc-embedded-open-formula calc-embedded-close-formula
=C2= =A0 align-mode-rules-list org-emphasis-alist
=C2=A0 org-emphasis-rege= xp-components
=C2=A0 org-export-registered-backends org-modules
= =C2=A0 org-babel-load-languages org-indent-indentation-per-level
=C2= =A0 org-element-paragraph-separate ffap-url-regexp
=C2=A0 org-inlinet= ask-min-level t)
=C2=A0nil
=C2=A0(add-hook (quote change-major-= mode-hook)
=C2=A0 (quote org-show-all) (quote append) (quote local))<= br> =C2=A0)
(closure
=C2=A0(org-src-window-setup *this*
= =C2=A0 org-babel-confirm-evaluate-answer-no
=C2=A0 org-src-preserve-= indentation org-src-lang-modes
=C2=A0 org-edit-src-content-indentatio= n org-babel-library-of-babel
=C2=A0 t)
=C2=A0nil
=C2=A0(a= dd-hook (quote change-major-mode-hook)
=C2=A0 (quote org-babel-show-r= esult-all) (quote append)
=C2=A0 (quote local))
=C2=A0)
o= rg-babel-result-hide-spec org-babel-hide-all-hashes)
=C2=A0org-bibtex-he= adline-format-function '(closure
=C2=A0 =C2=A0 =C2=A0 (org-id-l= ocations
org-agenda-search-view-always-boolean
org-agenda-o= verriding-header t)
=C2=A0 =C2=A0 =C2=A0 (entry) (cdr (assq :title = entry)))
=C2=A0org-archive-hook '(org-attach-archive-delete-maybe)=C2=A0org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-sho= w-empty-lines
=C2=A0org-optimize-window-after-visibility-change)
= =C2=A0org-link-shell-confirm-function 'yes-or-no-p
=C2=A0org-link-el= isp-confirm-function 'yes-or-no-p
=C2=A0org-confirm-elisp-link-funct= ion 'yes-or-no-p
=C2=A0org-metadown-hook '(org-babel-pop-to-sess= ion-maybe)
=C2=A0org-link-parameters '(("attachment" :foll= ow org-attach-open-link :export
org-attach-export-link :complete
= org-attach-complete-link)
=C2=A0 =C2=A0 =C2=A0 ("id" :fol= low org-id-open)
=C2=A0 =C2=A0 =C2=A0 ("eww" :follow eww :s= tore org-eww-store-link)
=C2=A0 =C2=A0 =C2=A0 ("rmail" :fol= low org-rmail-open :store
org-rmail-store-link)
=C2=A0 =C2=A0 = =C2=A0 ("mhe" :follow org-mhe-open :store org-mhe-store-link)
= =C2=A0 =C2=A0 =C2=A0 ("irc" :follow org-irc-visit :store org-i= rc-store-link
:export org-irc-export)
=C2=A0 =C2=A0 =C2=A0 (&qu= ot;info" :follow org-info-open :export org-info-export
:store or= g-info-store-link)
=C2=A0 =C2=A0 =C2=A0 ("gnus" :follow org= -gnus-open :store
org-gnus-store-link)
=C2=A0 =C2=A0 =C2=A0 (&q= uot;docview" :follow org-docview-open :export
org-docview-export= :store org-docview-store-link)
=C2=A0 =C2=A0 =C2=A0 ("bibtex&qu= ot; :follow org-bibtex-open :store
org-bibtex-store-link)
=C2= =A0 =C2=A0 =C2=A0 ("bbdb" :follow org-bbdb-open :export org-bbdb-= export
:complete org-bbdb-complete-link :store
org-bbdb-store-l= ink)
=C2=A0 =C2=A0 =C2=A0 ("w3m" :store org-w3m-store-link)= ("file+sys")
=C2=A0 =C2=A0 =C2=A0 ("file+emacs")= ("shell" :follow org-link--open-shell)
=C2=A0 =C2=A0 =C2= =A0 ("news" :follow
(closure
((scheme . "news&q= uot;) (--dolist-tail--) org-ts-regexp
=C2=A0org-time-stamp-formats o= rg-src-source-file-name
=C2=A0org-outline-regexp-bol org-inhibit-sta= rtup
=C2=A0org-id-link-to-org-use-id org-highlight-links
=C2= =A0org-comment-string org-agenda-buffer-name
=C2=A0clean-buffer-list= -kill-buffer-names t)
(url) (browse-url (concat scheme ":"= url)))
)
=C2=A0 =C2=A0 =C2=A0 ("mailto" :follow
= (closure
((scheme . "mailto") (--dolist-tail--) org-ts-r= egexp
=C2=A0org-time-stamp-formats org-src-source-file-name
= =C2=A0org-outline-regexp-bol org-inhibit-startup
=C2=A0org-id-link-t= o-org-use-id org-highlight-links
=C2=A0org-comment-string org-agenda= -buffer-name
=C2=A0clean-buffer-list-kill-buffer-names t)
(ur= l) (browse-url (concat scheme ":" url)))
)
=C2=A0 =C2= =A0 =C2=A0 ("https" :follow
(closure
((scheme . &quo= t;https") (--dolist-tail--) org-ts-regexp
=C2=A0org-time-stamp-= formats org-src-source-file-name
=C2=A0org-outline-regexp-bol org-in= hibit-startup
=C2=A0org-id-link-to-org-use-id org-highlight-links =C2=A0org-comment-string org-agenda-buffer-name
=C2=A0clean-buf= fer-list-kill-buffer-names t)
(url) (browse-url (concat scheme "= ;:" url)))
)
=C2=A0 =C2=A0 =C2=A0 ("http" :follo= w
(closure
((scheme . "http") (--dolist-tail--) org-= ts-regexp
=C2=A0org-time-stamp-formats org-src-source-file-name
= =C2=A0org-outline-regexp-bol org-inhibit-startup
=C2=A0org-id-lin= k-to-org-use-id org-highlight-links
=C2=A0org-comment-string org-age= nda-buffer-name
=C2=A0clean-buffer-list-kill-buffer-names t)
= (url) (browse-url (concat scheme ":" url)))
)
=C2=A0 = =C2=A0 =C2=A0 ("ftp" :follow
(closure
((scheme . &qu= ot;ftp") (--dolist-tail--) org-ts-regexp
=C2=A0org-time-stamp-f= ormats org-src-source-file-name
=C2=A0org-outline-regexp-bol org-inh= ibit-startup
=C2=A0org-id-link-to-org-use-id org-highlight-links
= =C2=A0org-comment-string org-agenda-buffer-name
=C2=A0clean-buff= er-list-kill-buffer-names t)
(url) (browse-url (concat scheme "= :" url)))
)
=C2=A0 =C2=A0 =C2=A0 ("help" :follow= org-link--open-help)
=C2=A0 =C2=A0 =C2=A0 ("file" :complet= e org-link-complete-file)
=C2=A0 =C2=A0 =C2=A0 ("elisp" :fo= llow org-link--open-elisp)
=C2=A0 =C2=A0 =C2=A0 ("doi" :fol= low org-link--open-doi))
=C2=A0org-clock-out-hook '(org-clock-remove= -empty-clock-drawer)
=C2=A0)
--000000000000390ece059fb7edd8--