[O] g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)]

[Quazgar]

As hinted on the manual http://orgmode.org/manual/Column-formulas.html
and written explicitly on a StackOverflow topic
http://emacs.stackexchange.com/questions/15185/cant-assign-to-hline-relative-reference,
the left hand side of table formulas currently cannot contain
references:

  The left-hand side of a column formula cannot be the name of column,
  it must be the numeric column reference or $>.

In examples like the following, this would be very convenient though:

| Value 1 | Value 2 | Sum |
|---------+---------+-----|
|       1 |       1 |     |
|       3 |       4 |     |
|---------+---------+-----|
| Average | of sums |     |
#+TBLFM: @address@hidden::$3=vmean(@address@hidden)

If I remember correctly, it used to work (I found a similar line in
org documents from June 2015).  Is it possible to have this feature
(back), now officially?

Best,

quazgar


Emacs  : GNU Emacs 24.5.1 (x86_64-pc-linux-gnu, GTK+ Version 3.22.7)
 of 2017-01-22 on trouble, modified by Debian
Package: Org mode version 9.0.5 (9.0.5-elpa @ 
/home/xxx/.emacs.d/elpa/org-20170210/)

current state:
==============
(setq
 org-src-lang-modes '(("ocaml" . tuareg) ("elisp" . emacs-lisp)
                      ("ditaa" . artist) ("asymptote" . asy)
                      ("dot" . fundamental) ("sqlite" . sql)
                      ("calc" . fundamental) ("C" . c) ("cpp" . c++)
                      ("screen" . shell-script) ("dot" . 
graphviz-dot-mode))
 org-export-backends '(ascii html icalendar latex md odt org)
 org-tab-first-hook '(org-babel-hide-result-toggle-maybe
                      org-babel-header-arg-expand)
 org-speed-command-hook '(org-speed-command-default-hook
                          org-babel-speed-command-hook)
 org-time-clocksum-format '(:hours "%d" :require-hours t :minutes 
":%02d"
                            :require-minutes t)
 org-clock-history-length 100
 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-pretty-entities t
 org-use-sub-superscripts '{}
 org-after-todo-state-change-hook '(org-clock-out-if-current)
 org-from-is-user-regexp "\\<XXX\\>"
 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-agenda-clock-consistency-checks '(:max-duration "10:00" 
:min-duration 0
                                       :max-gap "0:05" :gap-ok-around
                                       ("12:30" "00:00") :default-face
                                       ((:background "DarkRed")
                                        (:foreground "white"))
                                       :overlap-face nil :gap-face
                                       ((:background "coral")
                                        (:foreground "black"))
                                       :no-end-time-face
                                       ((:background "lime green")
                                        (:foreground "black"))
                                       :long-face nil :short-face nil)
 org-pretty-entities-include-sub-superscripts nil
 org-babel-pre-tangle-hook '(save-buffer)
 org-mode-hook '(#[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook org-show-block-all 
append
                    local]
                   5 "\n\n(fn)"]
                 #[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook 
org-babel-show-result-all
                    append local]
                   5 "\n\n(fn)"]
                 org-babel-result-hide-spec org-babel-hide-all-hashes)
 org-archive-hook '(org-attach-archive-delete-maybe)
 org-cycle-hook '(org-cycle-hide-archived-subtrees 
org-cycle-hide-drawers
                  org-cycle-show-empty-lines
                  org-optimize-window-after-visibility-change)
 org-mouse-1-follows-link nil
 org-catch-invisible-edits 'show-and-error
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 org-log-into-drawer t
 org-clock-clocktable-default-properties '(:maxlevel 3 :scope file)
 org-startup-truncated nil
 org-link-parameters '(("id" :follow org-id-open)
                       ("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)
                       ("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") ("doi" :follow org--open-doi-link)
                       ("elisp" :follow org--open-elisp-link)
                       ("file" :complete org-file-complete-link)
                       ("ftp" :follow
                        (lambda (path) (browse-url (concat "ftp:" 
path))))
                       ("help" :follow org--open-help-link)
                       ("http" :follow
                        (lambda (path) (browse-url (concat "http:" 
path))))
                       ("https" :follow
                        (lambda (path) (browse-url (concat "https:" 
path))))
                       ("mailto" :follow
                        (lambda (path) (browse-url (concat "mailto:"; 
path))))
                       ("message" :follow
                        (lambda (path) (browse-url (concat "message:" 
path))))
                       ("news" :follow
                        (lambda (path) (browse-url (concat "news:"; 
path))))
                       ("shell" :follow org--open-shell-link))
 org-babel-load-languages '((dot . t))
 org-table-default-size "4x4"
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 org-time-clocksum-use-effort-durations t
 )


--
Mein öffentlicher Schlüssel / My public key: 0x600ACB3B 2012-04-01
Fingerabdruck / Fingerprint:
9902 575B B9A0 C339 CFDF  250B 9267 CA6B 600A CB3B
Runterladen z.B. bei/ Get it e.g. here:
pgp.mit.edu, subkeys.pgp.net, pgp.uni-mainz.de, pool.sks-keyservers.net, 
...