I am re-sending because I didn't include everyone on the original message. ---------- Forwarded message ---------- From: Luke Swart <luke.sw...@gmail.com> Date: Tue, Sep 1, 2015 at 1:10 AM Subject: Re: can't assign to hline relative reference To: Luke Swart <luke.sw...@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 <m...@nicolasgoaziou.fr> wrote: Hello, > > Luke Swart <luke.sw...@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 >
