* can't assign to hline relative reference
@ 2015-08-31 2:47 Luke Swart
2015-09-01 7:47 ` Nicolas Goaziou
0 siblings, 1 reply; 5+ messages in thread
From: Luke Swart @ 2015-08-31 2:47 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1918 bytes --]
Hello,
There seems to be an error when using hline-relative references in an
org-mode table’s formula. For example, I have the following org-mode table:
#+BEGIN: columnview :hlines 1 :id global
| /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | /Total/ |
|----------------+-----+-----+-----+------+-----+------+-----+---------|
| AnotherProduct | | | | | | 2.50 | | |
| Prototype | | | | 3.50 | | | | |
|----------------+-----+-----+-----+------+-----+------+-----+---------|
| /Daily/ | | | | | | | | |
#+TBLFM: @I$9..@II$9=vsum($2..$8);%.2f;::@II$2..@III$9='(format
"%3.2f" (apply '+ '(@I..@II)));N;
and I get the error can't assign to hline relative reference when I run M-x
org-table-recalculate. I looked over the org-mode references documentation
<http://orgmode.org/manual/References.html> and the gmane.org forums
<http://comments.gmane.org/gmane.emacs.orgmode/86960>, but I did not find
any reasons as to why the hline relative references could not be assigned.
This issue is related to the timesheet package on MELPA. I have filed an
issue here: https://github.com/tmarble/timesheet.el/issues/3 but hopefully
I have found the underlying problem, and hopefully it is reasonably fixable.
Here is some relevant info:
-
Org-mode version 8.3.1 (8.3.1-87-g4ef2c0-elpa @
/home/luke/.emacs.d/elpa/org-20150824/)
-
emacs-version: 24.5.1
-
ArchLinux OS: Linux 4.1.6-1-ARCH #1 SMP PREEMPT Mon Aug 17 08:52:28 CEST
2015 x86_64 GNU/Linux
This is a copy of my question posted here:
http://emacs.stackexchange.com/questions/15185/cant-assign-to-hline-relative-reference
Any suggestions or guidance would be appreciated. I am happy to clarify
anything as well.
Thanks,
Luke
[-- Attachment #2: Type: text/html, Size: 8048 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread* Re: can't assign to hline relative reference 2015-08-31 2:47 can't assign to hline relative reference Luke Swart @ 2015-09-01 7:47 ` Nicolas Goaziou 2015-09-01 8:10 ` Luke Swart 0 siblings, 1 reply; 5+ messages in thread From: Nicolas Goaziou @ 2015-09-01 7:47 UTC (permalink / raw) To: Luke Swart; +Cc: emacs-orgmode Hello, Luke Swart <luke.swart@gmail.com> writes: > There seems to be an error when using hline-relative references in an > org-mode table’s formula. For example, I have the following org-mode table: > > #+BEGIN: columnview :hlines 1 :id global > | /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | /Total/ | > |----------------+-----+-----+-----+------+-----+------+-----+---------| > | AnotherProduct | | | | | | 2.50 | | | > | Prototype | | | | 3.50 | | | | | > |----------------+-----+-----+-----+------+-----+------+-----+---------| > | /Daily/ | | | | | | | | | > #+TBLFM: @I$9..@II$9=vsum($2..$8);%.2f;::@II$2..@III$9='(format > "%3.2f" (apply '+ '(@I..@II)));N; > > and I get the error can't assign to hline relative reference when I run M-x > org-table-recalculate. I looked over the org-mode references documentation > <http://orgmode.org/manual/References.html> and the gmane.org forums > <http://comments.gmane.org/gmane.emacs.orgmode/86960>, but I did not find > any reasons as to why the hline relative references could not be > assigned. This is a known limitation: hline relative references are not allowed on the left hand side of a formula. The error message you get should be explicit. There are apparently subtle problems, IIRC, as pointed out in <http://comments.gmane.org/gmane.emacs.orgmode/86960>. Regards, -- Nicolas Goaziou ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: can't assign to hline relative reference 2015-09-01 7:47 ` Nicolas Goaziou @ 2015-09-01 8:10 ` Luke Swart 2015-09-01 8:17 ` Fwd: " Luke Swart 2015-09-01 8:37 ` Nicolas Goaziou 0 siblings, 2 replies; 5+ messages in thread From: Luke Swart @ 2015-09-01 8:10 UTC (permalink / raw) To: Luke Swart, emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 2509 bytes --] Hi Nicolas Goaziou, Thanks very much for your clarification: hline relative references are not allowed on the left hand side of a formula My error message was user-error: Can't assign to hline relative reference, which now makes sense. Still, a lot of folks didn’t understand the original message, myself included. I will update my SO post and the Github issue to reflect this new information. Still, I am confused because it seems like org-mode used to allow hline references to be assigned, no? My code snippet was taken from a section in the timesheet.el MELPA package, which was working fine until an org-mode update broke it. I may be missing something, so I am not sure if this is the case. Anyway, your response is very much appreciated! Thanks, Luke On Tue, Sep 1, 2015 at 12:47 AM, Nicolas Goaziou <mail@nicolasgoaziou.fr> wrote: Hello, > > Luke Swart <luke.swart@gmail.com> writes: > > > There seems to be an error when using hline-relative references in an > > org-mode table’s formula. For example, I have the following org-mode > table: > > > > #+BEGIN: columnview :hlines 1 :id global > > | /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | > /Total/ | > > > |----------------+-----+-----+-----+------+-----+------+-----+---------| > > | AnotherProduct | | | | | | 2.50 | | > | > > | Prototype | | | | 3.50 | | | | > | > > > |----------------+-----+-----+-----+------+-----+------+-----+---------| > > | /Daily/ | | | | | | | | > | > > #+TBLFM: @I$9..@II$9=vsum($2..$8);%.2f;::@II$2..@III$9='(format > > "%3.2f" (apply '+ '(@I..@II)));N; > > > > and I get the error can't assign to hline relative reference when I run > M-x > > org-table-recalculate. I looked over the org-mode references > documentation > > <http://orgmode.org/manual/References.html> and the gmane.org forums > > <http://comments.gmane.org/gmane.emacs.orgmode/86960>, but I did not > find > > any reasons as to why the hline relative references could not be > > assigned. > > This is a known limitation: hline relative references are not allowed on > the left hand side of a formula. The error message you get should be > explicit. > > There are apparently subtle problems, IIRC, as pointed out in > <http://comments.gmane.org/gmane.emacs.orgmode/86960>. > > > Regards, > > -- > Nicolas Goaziou > [-- Attachment #2: Type: text/html, Size: 10319 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
* Fwd: can't assign to hline relative reference 2015-09-01 8:10 ` Luke Swart @ 2015-09-01 8:17 ` Luke Swart 2015-09-01 8:37 ` Nicolas Goaziou 1 sibling, 0 replies; 5+ messages in thread From: Luke Swart @ 2015-09-01 8:17 UTC (permalink / raw) To: mail; +Cc: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 2825 bytes --] I am re-sending because I didn't include everyone on the original message. ---------- Forwarded message ---------- From: Luke Swart <luke.swart@gmail.com> Date: Tue, Sep 1, 2015 at 1:10 AM Subject: Re: can't assign to hline relative reference To: Luke Swart <luke.swart@gmail.com>, emacs-orgmode@gnu.org Hi Nicolas Goaziou, Thanks very much for your clarification: hline relative references are not allowed on the left hand side of a formula My error message was user-error: Can't assign to hline relative reference, which now makes sense. Still, a lot of folks didn’t understand the original message, myself included. I will update my SO post and the Github issue to reflect this new information. Still, I am confused because it seems like org-mode used to allow hline references to be assigned, no? My code snippet was taken from a section in the timesheet.el MELPA package, which was working fine until an org-mode update broke it. I may be missing something, so I am not sure if this is the case. Anyway, your response is very much appreciated! Thanks, Luke On Tue, Sep 1, 2015 at 12:47 AM, Nicolas Goaziou <mail@nicolasgoaziou.fr> wrote: Hello, > > Luke Swart <luke.swart@gmail.com> writes: > > > There seems to be an error when using hline-relative references in an > > org-mode table’s formula. For example, I have the following org-mode > table: > > > > #+BEGIN: columnview :hlines 1 :id global > > | /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | > /Total/ | > > > |----------------+-----+-----+-----+------+-----+------+-----+---------| > > | AnotherProduct | | | | | | 2.50 | | > | > > | Prototype | | | | 3.50 | | | | > | > > > |----------------+-----+-----+-----+------+-----+------+-----+---------| > > | /Daily/ | | | | | | | | > | > > #+TBLFM: @I$9..@II$9=vsum($2..$8);%.2f;::@II$2..@III$9='(format > > "%3.2f" (apply '+ '(@I..@II)));N; > > > > and I get the error can't assign to hline relative reference when I run > M-x > > org-table-recalculate. I looked over the org-mode references > documentation > > <http://orgmode.org/manual/References.html> and the gmane.org forums > > <http://comments.gmane.org/gmane.emacs.orgmode/86960>, but I did not > find > > any reasons as to why the hline relative references could not be > > assigned. > > This is a known limitation: hline relative references are not allowed on > the left hand side of a formula. The error message you get should be > explicit. > > There are apparently subtle problems, IIRC, as pointed out in > <http://comments.gmane.org/gmane.emacs.orgmode/86960>. > > > Regards, > > -- > Nicolas Goaziou > [-- Attachment #2: Type: text/html, Size: 10914 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: can't assign to hline relative reference 2015-09-01 8:10 ` Luke Swart 2015-09-01 8:17 ` Fwd: " Luke Swart @ 2015-09-01 8:37 ` Nicolas Goaziou 1 sibling, 0 replies; 5+ messages in thread From: Nicolas Goaziou @ 2015-09-01 8:37 UTC (permalink / raw) To: Luke Swart; +Cc: emacs-orgmode Luke Swart <luke.swart@gmail.com> writes: > Still, I am confused because it seems like org-mode used to allow hline > references to be assigned, no? As Carsten pointed out, that was a bug, as Org couldn't expand them correctly anyway. As a consequence, an error is now thrown. Regards, ^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2015-09-01 8:35 UTC | newest] Thread overview: 5+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2015-08-31 2:47 can't assign to hline relative reference Luke Swart 2015-09-01 7:47 ` Nicolas Goaziou 2015-09-01 8:10 ` Luke Swart 2015-09-01 8:17 ` Fwd: " Luke Swart 2015-09-01 8:37 ` 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).