emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Dante Catalfamo <dante@lambda.cx>
To: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>
Subject: Bug: Can’t assign to hline relative reference
Date: Tue, 20 Oct 2020 21:39:33 +0000	[thread overview]
Message-ID: <FLG5SM42U_NbZ0jwGhFooc9Sx7XaJ3sX5nCQ_oKeoB_WExzIItBi6q6o2-dyDS6yghkaePKNf97virgS29X5Txsoc_F_cxw1jAAhKmuRFGQ=@lambda.cx> (raw)

Hello,

I'm trying to create a table where the third column between two hlines is set by a formula referencing the second column.

Here is an example:

| a     |     b |      c |
|-------+-------+--------|
| row 1 | 12.00 | 144.00 |
| row 2 |       |  23.00 |
|-------+-------+--------|
| sum   | 12.00 | 167.00 |
#+TBLFM: @I$3..II$3=if($2 != 0, 12*$2, $3);%.2f::@4$2=vsum(@I..II);%.2f::@4$3=vsum(@I..II);%.2f

When I try to calculate this table however, I get the error "Can’t assign to hline relative reference".

Why is this now allowed? This seems like a fairly mundane use of a table to me. It is explicitly disabled in the source, but without explanation, and searching the mailing list doesn't turn up many answers.

Is there a recommended way to handle a situation like this?

Could this feature be fixed?

Thank you,
Dante


             reply	other threads:[~2020-10-22 13:32 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-10-20 21:39 Dante Catalfamo [this message]
2020-10-21  1:14 Dante Catalfamo
2020-10-21 12:43 ` Daniel Herzig
2020-10-21 16:14   ` Dante Catalfamo
2020-10-22 12:04     ` Maxim Nikulin
2020-10-22 19:56       ` Dante Catalfamo
2020-10-29 12:40         ` Maxim Nikulin

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='FLG5SM42U_NbZ0jwGhFooc9Sx7XaJ3sX5nCQ_oKeoB_WExzIItBi6q6o2-dyDS6yghkaePKNf97virgS29X5Txsoc_F_cxw1jAAhKmuRFGQ=@lambda.cx' \
    --to=dante@lambda.cx \
    --cc=emacs-orgmode@gnu.org \
    --subject='Re: Bug: Can’t assign to hline relative reference' \
    /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 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).