Re: can't assign to hline relative reference

[Nicolas Goaziou <mail@nicolasgoaziou.fr>]

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