From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Subject: Re: can't assign to hline relative reference
Date: Tue, 01 Sep 2015 09:47:09 +0200
Message-ID: <87613u4m4i.fsf@nicolasgoaziou.fr>
References: <CAAe54uxUZtGd80DfCuc6ox5c8vkfEiHxxyMg5bZsMSJMxnM1iA@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:55729)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZWgG4-0003z0-1G
	for emacs-orgmode@gnu.org; Tue, 01 Sep 2015 03:45:33 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZWgG2-000205-Mt
	for emacs-orgmode@gnu.org; Tue, 01 Sep 2015 03:45:31 -0400
Received: from relay4-d.mail.gandi.net ([2001:4b98:c:538::196]:55975)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZWgG2-0001zT-Fb
	for emacs-orgmode@gnu.org; Tue, 01 Sep 2015 03:45:30 -0400
In-Reply-To: <CAAe54uxUZtGd80DfCuc6ox5c8vkfEiHxxyMg5bZsMSJMxnM1iA@mail.gmail.com>
	(Luke Swart's message of "Sun, 30 Aug 2015 19:47:50 -0700")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Luke Swart <luke.swart@gmail.com>
Cc: emacs-orgmode@gnu.org

Hello,

Luke Swart <luke.swart@gmail.com> writes:

> There seems to be an error when using hline-relative references in an
> org-mode table=E2=80=99s formula. For example, I have the following org-m=
ode 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=3Dvsum($2..$8);%.2f;::@II$2..@III$9=3D'(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,

--=20
Nicolas Goaziou