emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Dante Catalfamo <dante@lambda.cx>
To: Daniel Herzig <daniel.herzig@outlook.at>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>
Subject: Re: Bug: Can’t assign to hline relative reference
Date: Wed, 21 Oct 2020 16:14:06 +0000	[thread overview]
Message-ID: <eMq4RdPFFPP4nvjgGRF8TeV8tFRYYiq7Ylucq7Y5IzszZRSm_EmrKrvrXtJwWsydGhqy2aWxlBwD27SaEhzyzuConlbbFmoM8KRmYOgyhQU=@lambda.cx> (raw)
In-Reply-To: <DB7PR09MB2234AB43B73868D765EB1682861C0@DB7PR09MB2234.eurprd09.prod.outlook.com>

[-- Attachment #1: Type: text/plain, Size: 2280 bytes --]

In the case where I'm using this formula, there are many more rows
between @I..@II. I only used two in the example to keep the email small.
I would also be adding more rows regularly, making it slightly
impractical to be adjusting the beginning and end points of the formula
every time I add or remove a row. I appreciate your suggestion, though I
was hoping for a more convenient solution. If nothing else works, that's
what I'll do.

I'd like to get to the bottom of why hlines aren't permitted in table
formulas, it seems like something that should be allowed.

Thanks,
Dante

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Wednesday, October 21, 2020 8:43 AM, Daniel Herzig <daniel.herzig@outlook.at> wrote:

> This seems to be related to: https://emacs.stackexchange.com/questions/15185/cant-assign-to-hline-relative-reference
>
> There seem to be restrictions regarding hline-relative-references within table-formulas.
>
> If change 'I' and 'II' for 1 and 2 on the very left of the formula, it works (keeping the other hline-relative parts) . If I stay with the former I get the same error as you (emacs 26.1, orgmode 9.1.9, Debian stable).
>
> I hope this can help,
> Daniel
>
> Am 21. Oktober 2020 03:14:10 MESZ schrieb Dante Catalfamo <dante@lambda.cx>:
>
>> 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
>
> --
> Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.

[-- Attachment #2: Type: text/html, Size: 3607 bytes --]

  reply	other threads:[~2020-10-21 16:14 UTC|newest]

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

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='eMq4RdPFFPP4nvjgGRF8TeV8tFRYYiq7Ylucq7Y5IzszZRSm_EmrKrvrXtJwWsydGhqy2aWxlBwD27SaEhzyzuConlbbFmoM8KRmYOgyhQU=@lambda.cx' \
    --to=dante@lambda.cx \
    --cc=daniel.herzig@outlook.at \
    --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).