* g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)]
@ 2017-02-17 10:02 Quazgar
2017-02-17 10:14 ` Nicolas Goaziou
0 siblings, 1 reply; 2+ messages in thread
From: Quazgar @ 2017-02-17 10:02 UTC (permalink / raw)
To: emacs-orgmode
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: @I$3..@II$3=$1+$2::$3=vmean(@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 @
/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,
...
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)]
2017-02-17 10:02 g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)] Quazgar
@ 2017-02-17 10:14 ` Nicolas Goaziou
0 siblings, 0 replies; 2+ messages in thread
From: Nicolas Goaziou @ 2017-02-17 10:14 UTC (permalink / raw)
To: Quazgar; +Cc: emacs-orgmode
Hello,
Quazgar <quazgar@posteo.de> writes:
> 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: @I$3..@II$3=$1+$2::$3=vmean(@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?
This feature was never introduced, at least in a correct implementation.
At some point, there was something like it, but it was broken and was
consequently removed.
AFAIR, relative references using hlines (e.g., @I) is not well defined
and is therefore difficult to implement. You may want to search the
mailing list archives about it.
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2017-02-17 10:14 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2017-02-17 10:02 g: Feature request: table formulas: resolve references on LHS [9.0.5 (9.0.5-elpa @ /home/daniel/.emacs.d/elpa/org-20170210/)] Quazgar
2017-02-17 10:14 ` Nicolas Goaziou
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).