From mboxrd@z Thu Jan 1 00:00:00 1970 From: Lukasz Wiechec Subject: Bug: problems with named fields on Org spreadsheet [8.3.2 (release_8.3.2-338-g522ec9 @ /home/luke/.emacs.d/el-get/org-mode/lisp/)] Date: Wed, 02 Dec 2015 13:06:27 +0100 Message-ID: <15162962a3d.e1158fd1621852.7850584471864259419@wiechec.eu> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_601373_1816917783.1449057987132" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37105) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a46BH-0003Bc-Lu for emacs-orgmode@gnu.org; Wed, 02 Dec 2015 07:06:47 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1a46B6-0002cT-Ez for emacs-orgmode@gnu.org; Wed, 02 Dec 2015 07:06:43 -0500 Received: from sender163-mail.zoho.com ([74.201.84.163]:25322) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a46B6-0002Xh-23 for emacs-orgmode@gnu.org; Wed, 02 Dec 2015 07:06:32 -0500 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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: "emacs-orgmode@gnu.org" ------=_Part_601373_1816917783.1449057987132 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit Hi, I just have updated from previous version of Org to the latest (from git) and my timesheet table stopped working. After looking closer, even the example sheet from the Org mode's info pages does not work. Here's the table (from the info pages): |---+---------+--------+--------+--------+-------+------| | | Student | Prob 1 | Prob 2 | Prob 3 | Total | Note | |---+---------+--------+--------+--------+-------+------| | ! | | P1 | P2 | P3 | Tot | | | # | Maximum | 10 | 15 | 25 | 50 | 10.0 | | ^ | | m1 | m2 | m3 | mt | | |---+---------+--------+--------+--------+-------+------| | # | Peter | 10 | 8 | 23 | 41 | 8.2 | | # | Sam | 2 | 4 | 3 | 9 | 1.8 | |---+---------+--------+--------+--------+-------+------| | # | Average | | | | 0 | 0.0 | | ^ | | | | | at | | | $ | max=50 | | | | | | |---+---------+--------+--------+--------+-------+------| #+TBLFM: $6=vsum($P1..$P3)::$7=10*$Tot/$max;%.1f::$at=vmean(@-II..@-I);%.1f When I try to re-apply the formulas (C-c C-c), I am getting a message 'Invalid table range specifier $at'. Remember to cover the basics, that is, what you expected to happen and what in fact did happen. You don't know how to make a good report? See http://orgmode.org/manual/Feedback.html#Feedback Your bug report will be posted to the Org-mode mailing list. ------------------------------------------------------------------------ Emacs : GNU Emacs 24.5.1 (x86_64-unknown-linux-gnu, GTK+ Version 3.10.8) of 2015-04-15 on luke-new-laptop Package: Org-mode version 8.3.2 (release_8.3.2-338-g522ec9 @ /home/luke/.emacs.d/el-get/org-mode/lisp/) current state: ============== (setq org-tab-first-hook '(org-hide-block-toggle-maybe org-babel-hide-result-toggle-maybe org-babel-header-arg-expand) org-babel-results-keyword "results" org-speed-command-hook '(org-speed-command-default-hook org-babel-speed-command-hook) 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-default-notes-file "~/Dropbox/org/notes.org" org-capture-templates '(("t" "Todo" entry (file+headline "~/Dropbox/org/agenda.org" "Tasks") (file "~/Dropbox/org/templates/todo.orgtmpl"))) org-agenda-include-diary t org-after-todo-state-change-hook '(org-clock-out-if-current) 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 '(org-clock-load #[nil "\300\301\302\303\304$\207" [org-add-hook change-major-mode-hook org-show-block-all append local] 5] #[nil "\300\301\302\303\304$\207" [org-add-hook change-major-mode-hook org-babel-show-result-all append local] 5] org-babel-result-hide-spec org-babel-hide-all-hashes org-eldoc-load) org-archive-hook '(org-attach-archive-delete-maybe) org-clock-persist 'history org-ctrl-c-ctrl-c-hook '(org-babel-hash-at-point org-babel-execute-safely-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-babel-tangle-lang-exts '(("latex" . "tex") ("clojure" . "clj") ("ruby" . "rb") ("python" . "py") ("emacs-lisp" . "el") ("elisp" . "el")) org-confirm-elisp-link-function 'yes-or-no-p org-metadown-hook '(org-babel-pop-to-session-maybe) org-babel-after-execute-hook '(bh/display-inline-images) org-ditaa-jar-path "/usr/share/ditaa/ditaa.jar" org-babel-load-languages '((emacs-lisp . t) (dot . t) (ditaa . t) (R . t) (python . t) (ruby . t) (gnuplot . t) (clojure . t) (sh . t) (ledger . t) (org . t) (latex . t)) org-agenda-files '("~/Dropbox/org/timesheet.2015.org" "/home/luke/Dropbox/org/agenda.org" "/home/luke/Dropbox/org/blackberry-comparison.org" "/home/luke/Dropbox/org/journal.org" "/home/luke/Dropbox/org/mobileorg.org" "/home/luke/Dropbox/org/notes.org" "/home/luke/Dropbox/org/todos.org" "/home/luke/Dropbox/org/deft/deft-0.org" "/home/luke/Dropbox/org/deft/deft-1.org" "/home/luke/Dropbox/org/deft/deft-10.org" "/home/luke/Dropbox/org/deft/deft-11.org" "/home/luke/Dropbox/org/deft/deft-12.org" "/home/luke/Dropbox/org/deft/deft-13.org" "/home/luke/Dropbox/org/deft/deft-14.org" "/home/luke/Dropbox/org/deft/deft-15.org" "/home/luke/Dropbox/org/deft/deft-16.org" "/home/luke/Dropbox/org/deft/deft-17.org" "/home/luke/Dropbox/org/deft/deft-18.org" "/home/luke/Dropbox/org/deft/deft-19.org" "/home/luke/Dropbox/org/deft/deft-2.org" "/home/luke/Dropbox/org/deft/deft-20.org" "/home/luke/Dropbox/org/deft/deft-21.org" "/home/luke/Dropbox/org/deft/deft-22.org" "/home/luke/Dropbox/org/deft/deft-23.org" "/home/luke/Dropbox/org/deft/deft-24.org" "/home/luke/Dropbox/org/deft/deft-25.org" "/home/luke/Dropbox/org/deft/deft-26.org" "/home/luke/Dropbox/org/deft/deft-27.org" "/home/luke/Dropbox/org/deft/deft-28 (luke-laptop's conflicted copy 2014-08-27).org" "/home/luke/Dropbox/org/deft/deft-28.org" "/home/luke/Dropbox/org/deft/deft-29.org" "/home/luke/Dropbox/org/deft/deft-3.org" "/home/luke/Dropbox/org/deft/deft-30.org" "/home/luke/Dropbox/org/deft/deft-31.org" "/home/luke/Dropbox/org/deft/deft-32.org" "/home/luke/Dropbox/org/deft/deft-33.org" "/home/luke/Dropbox/org/deft/deft-34.org" "/home/luke/Dropbox/org/deft/deft-35.org" "/home/luke/Dropbox/org/deft/deft-36.org" "/home/luke/Dropbox/org/deft/deft-37.org" "/home/luke/Dropbox/org/deft/deft-38.org" "/home/luke/Dropbox/org/deft/deft-39.org" "/home/luke/Dropbox/org/deft/deft-4.org" "/home/luke/Dropbox/org/deft/deft-40.org" "/home/luke/Dropbox/org/deft/deft-41.org" "/home/luke/Dropbox/org/deft/deft-5.org" "/home/luke/Dropbox/org/deft/deft-6.org" "/home/luke/Dropbox/org/deft/deft-7.org" "/home/luke/Dropbox/org/deft/deft-8.org" "/home/luke/Dropbox/org/deft/deft-9.org") org-clock-out-hook '(org-clock-remove-empty-clock-drawer) org-confirm-babel-evaluate nil ) ------=_Part_601373_1816917783.1449057987132 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =
Hi,

I just have updated from previous version of Org to the = latest (from
git) and my timesheet table stopped working. After looking cl= oser,
even the example sheet from the Org mode's info pages does not work.=

Here's the table (from the = info pages):

  &nb= sp;  |---+---------+--------+--------+--------+-------+------|<= span style=3D"font-family: "courier new",courier,monospace, sans-= serif;" class=3D"font">
 =     |   | Student | Prob 1 | Prob 2 | Prob 3 | Tot= al | Note |
     |---+---------+--------+--------+----= ----+-------+------|
     | ! |    = ;     |     P1 |   &= nbsp; P2 |     P3 |   Tot |   =    |
     | # | Maximum |   &= nbsp; 10 |     15 |     25 | &= nbsp;  50 | 10.0 |
     | ^ |   &n= bsp;     |     m1 |  &nbs= p;  m2 |     m3 |    mt | &nbs= p;    |
=      |---+---------+--------+--= ------+--------+-------+------|
     | # | Peter =   |     10 |      8 |&nbs= p;    23 |    41 |  8.2 |
  &= nbsp;  | # | Sam     |    &nbs= p; 2 |      4 |      3 |&= nbsp;    9 |  1.8 |
<= /span>
     |---+----= -----+--------+--------+--------+-------+------|
     = | # | Average |        |  &nbs= p;     |        |&nb= sp;    0 |  0.0 |
     | ^ | =         |     &= nbsp;  |        |   =      |    at |    &n= bsp; |
     | $ | max=3D50  |   =      |        | = ;       |      = |      |
     |---+---------= +--------+--------+--------+-------+------|<= br>
     #+TBL= FM: $6=3Dvsum($P1..$P3)::$7=3D10*$Tot/$max;%.1f::$at=3Dvmean(@-II..@-I);%.1= f

When I try to re-apply the= formulas (C-c C-c), I am getting a message<= br>

'Invalid table = range specifier $at'.
<= span style=3D"font-family: "courier new",courier,monospace, sans-= serif;" class=3D"font">

Remember to cover the basics, that = is, what you expected to happen and
what in fact did happen.  You don= 't know how to make a good report?  See=

     http://orgmode.org/manual/Feedbac= k.html#Feedback

Your bug rep= ort will be posted to the Org-mode mailing list.
-------------------------= -----------------------------------------------

Emacs  : GNU Emacs 24.5.1 (x86_64-unknown-linux-gn= u, GTK+ Version 3.10.8)
of 2015-04-15 on luke-new-laptop
Package: Org-mod= e version 8.3.2 (release_8.3.2-338-g522ec9 @ /home/luke/.emacs.d/el-get/org= -mode/lisp/)

current state:<= /span>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<= br>
(setq
org-tab-first-hook '(or= g-hide-block-toggle-maybe org-babel-hide-result-toggle-maybe org-babel-head= er-arg-expand)
org-babel-results-keyword "results"
org-speed-command-hook= '(org-speed-command-default-hook org-babel-speed-command-hook)
org-occur-= hook '(org-first-headline-recenter)
org-metaup-hook '(org-babel-load-in-se= ssion-maybe)
org-confirm-shell-link-function 'yes-or-no-p
org-default-not= es-file "~/Dropbox/org/notes.org"
=
org-capture-templates '(("t" "Todo" entr= y (file+headline "~/Dropbox/org/agenda.org" "Tasks") (file "~/Dropbox/org/t= emplates/todo.orgtmpl")))
org-agenda-include-diary t
org-after-todo-stat= e-change-hook '(org-clock-out-if-current)
org-src-mode-hook '(org-src-babe= l-configure-edit-buffer org-src-mode-configure-edit-buffer)
org-agenda-bef= ore-write-hook '(org-agenda-add-entry-text)<= br>
org-babel-pre-tangle-hook '(sa= ve-buffer)
org-mode-hook '(org-clock-load #[nil "\300\301\302\303\304$\20= 7" [org-add-hook change-major-mode-hook org-show-block-all append local] 5]=
            &= nbsp;    #[nil "\300\301\302\303\304$\207" [org-add-hook cha= nge-major-mode-hook org-babel-show-result-all append local] 5]
  = ;            &n= bsp;  org-babel-result-hide-spec org-babel-hide-all-hashes org-eldoc-l= oad)
org-archive-hook '(org-attach-archive-delete-maybe)
org-clock-persis= t 'history
org-ctrl-c-ctrl-c-hook '(org-babel-hash-at-point org-babel-exe= cute-safely-maybe)
org-cycle-hook '(org-cycle-hide-archived-subtrees org-c= ycle-hide-drawers org-cycle-show-empty-lines org-optimize-window-after-visi= bility-change)
org-babel-tangle-lang-exts '(("latex" . "tex") ("clojure" .= "clj") ("ruby" . "rb") ("python" . "py") ("emacs-lisp" . "el") ("elisp" . = "el"))
org-confirm-elisp-link-function 'yes-or-no-p
org-metadown-hook '= (org-babel-pop-to-session-maybe)
<= /div>
org-babel-after-execute-hook '(bh/display= -inline-images)
org-ditaa-jar-path "/usr/share/ditaa/ditaa.jar"
org-babel= -load-languages '((emacs-lisp . t) (dot . t) (ditaa . t) (R . t) (python . = t) (ruby . t) (gnuplot . t) (clojure . t) (sh . t) (ledger . t)
 &nbs= p;            &= nbsp;           &nbs= p; (org . t) (latex . t))
org-agenda-files '("~/Dropbox/org/timesheet.2015= .org" "/home/luke/Dropbox/org/agenda.org" "/home/luke/Dropbox/org/blackberr= y-comparison.org"
         &n= bsp;          "/home/luke/Drop= box/org/journal.org" "/home/luke/Dropbox/org/mobileorg.org" "/home/luke/Dro= pbox/org/notes.org"
         =            "/home/luke/Dr= opbox/org/todos.org" "/home/luke/Dropbox/org/deft/deft-0.org" "/home/luke/D= ropbox/org/deft/deft-1.org"
=
       &nbs= p;            "/home= /luke/Dropbox/org/deft/deft-10.org" "/home/luke/Dropbox/org/deft/deft-11.or= g" "/home/luke/Dropbox/org/deft/deft-12.org"=
     = ;            &n= bsp;  "/home/luke/Dropbox/org/deft/deft-13.org" "/home/luke/Dropbox/or= g/deft/deft-14.org" "/home/luke/Dropbox/org/deft/deft-15.org"
  =             &nb= sp;     "/home/luke/Dropbox/org/deft/deft-16.org" "/hom= e/luke/Dropbox/org/deft/deft-17.org" "/home/luke/Dropbox/org/deft/deft-18.o= rg"
           &nbs= p;        "/home/luke/Dropbox/org/deft/d= eft-19.org" "/home/luke/Dropbox/org/deft/deft-2.org" "/home/luke/Dropbox/or= g/deft/deft-20.org"
         =            "/home/luke/Dr= opbox/org/deft/deft-21.org" "/home/luke/Dropbox/org/deft/deft-22.org" "/hom= e/luke/Dropbox/org/deft/deft-23.org"
      &= nbsp;           &nbs= p; "/home/luke/Dropbox/org/deft/deft-24.org" "/home/luke/Dropbox/org/deft/d= eft-25.org" "/home/luke/Dropbox/org/deft/deft-26.org"
   &= nbsp;           &nbs= p;    "/home/luke/Dropbox/org/deft/deft-27.org" "/home/luke/= Dropbox/org/deft/deft-28 (luke-laptop's conflicted copy 2014-08-27).org"
&= nbsp;           &nbs= p;       "/home/luke/Dropbox/org/deft/deft-28= .org" "/home/luke/Dropbox/org/deft/deft-29.org" "/home/luke/Dropbox/org/def= t/deft-3.org"
          =           "/home/luke/Dropbox/= org/deft/deft-30.org" "/home/luke/Dropbox/org/deft/deft-31.org" "/home/luke= /Dropbox/org/deft/deft-32.org"
       &= nbsp;            "/h= ome/luke/Dropbox/org/deft/deft-33.org" "/home/luke/Dropbox/org/deft/deft-34= .org" "/home/luke/Dropbox/org/deft/deft-35.org"
    &n= bsp;            = ;   "/home/luke/Dropbox/org/deft/deft-36.org" "/home/luke/Dropbox= /org/deft/deft-37.org" "/home/luke/Dropbox/org/deft/deft-38.org"
 &nb= sp;            =       "/home/luke/Dropbox/org/deft/deft-39.org" "/= home/luke/Dropbox/org/deft/deft-4.org" "/home/luke/Dropbox/org/deft/deft-40= .org"
           &n= bsp;        "/home/luke/Dropbox/org/deft= /deft-41.org" "/home/luke/Dropbox/org/deft/deft-5.org" "/home/luke/Dropbox/= org/deft/deft-6.org"
         = ;           "/home/luke/D= ropbox/org/deft/deft-7.org" "/home/luke/Dropbox/org/deft/deft-8.org" "/home= /luke/Dropbox/org/deft/deft-9.org")
org-clock-out-hook '(org-clock-remove-= empty-clock-drawer)
org-confirm-babel-evaluate nil
)

------=_Part_601373_1816917783.1449057987132--