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