Re: [O] 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 Thread Nicolas Goaziou 
Hello,

Quazgar  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

[O] 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 Thread 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: @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 "\\"
 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