emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
To: Luke Swart <luke.swart@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: can't assign to hline relative reference
Date: Tue, 01 Sep 2015 09:47:09 +0200	[thread overview]
Message-ID: <87613u4m4i.fsf@nicolasgoaziou.fr> (raw)
In-Reply-To: <CAAe54uxUZtGd80DfCuc6ox5c8vkfEiHxxyMg5bZsMSJMxnM1iA@mail.gmail.com> (Luke Swart's message of "Sun, 30 Aug 2015 19:47:50 -0700")

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

next prev parent reply	other threads:[~2015-09-01  7:45 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2015-08-31  2:47 can't assign to hline relative reference Luke Swart
2015-09-01  7:47 ` Nicolas Goaziou [this message]
2015-09-01  8:10   ` Luke Swart
2015-09-01  8:17     ` Fwd: " Luke Swart
2015-09-01  8:37     ` Nicolas Goaziou

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87613u4m4i.fsf@nicolasgoaziou.fr \
    --to=mail@nicolasgoaziou.fr \
    --cc=emacs-orgmode@gnu.org \
    --cc=luke.swart@gmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

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).