From mboxrd@z Thu Jan 1 00:00:00 1970 From: Quazgar Subject: g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)] Date: Fri, 17 Feb 2017 11:02:44 +0100 Message-ID: <8f26b1fb6dde9b543aa1090c6e3dd8bc@posteo.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:42149) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cefNO-00057u-1l for emacs-orgmode@gnu.org; Fri, 17 Feb 2017 05:02:56 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cefNJ-0003Ia-4i for emacs-orgmode@gnu.org; Fri, 17 Feb 2017 05:02:54 -0500 Received: from mout02.posteo.de ([185.67.36.66]:54738) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1cefNI-0003GH-QU for emacs-orgmode@gnu.org; Fri, 17 Feb 2017 05:02:49 -0500 Received: from submission (posteo.de [89.146.220.130]) by mout02.posteo.de (Postfix) with ESMTPS id E52C420BCB for ; Fri, 17 Feb 2017 11:02:45 +0100 (CET) Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 3vPpVY2w5LzyZZ for ; Fri, 17 Feb 2017 11:02:44 +0100 (CET) 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.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org 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-relativ= e-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: @I$3..@II$3=3D$1+$2::$3=3Dvmean(@I..@II) 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 @=20 /home/xxx/.emacs.d/elpa/org-20170210/) current state: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D (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" .=20 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=20 ":%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 "\\" 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"=20 :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=20 append local] 5 "\n\n(fn)"] #[0 "\300\301\302\303\304$\207" [add-hook change-major-mode-hook=20 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=20 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=20 org-mhe-store-link) ("irc" :follow org-irc-visit :store=20 org-irc-store-link) ("info" :follow org-info-open :export=20 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=20 org-docview-store-link) ("bibtex" :follow org-bibtex-open :store org-bibtex-store-link) ("bbdb" :follow org-bbdb-open :export=20 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:"=20 path)))) ("help" :follow org--open-help-link) ("http" :follow (lambda (path) (browse-url (concat "http:"=20 path)))) ("https" :follow (lambda (path) (browse-url (concat "https:"=20 path)))) ("mailto" :follow (lambda (path) (browse-url (concat "mailto:"=20 path)))) ("message" :follow (lambda (path) (browse-url (concat "message:"=20 path)))) ("news" :follow (lambda (path) (browse-url (concat "news:"=20 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 ) --=20 Mein =C3=B6ffentlicher Schl=C3=BCssel / My public key: 0x600ACB3B 2012-04-0= 1 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,=20 =2E..