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
next 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]
-- strict thread matches above, loose matches on Subject: below --
2020-10-21 1:14 Bug: Can’t assign to hline relative reference 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 \
/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
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).