From: Dante Catalfamo <email@example.com> To: Daniel Herzig <firstname.lastname@example.org> Cc: "email@example.com" <firstname.lastname@example.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_EmrKrvrXtJwWsydGhqy2aWxlBwD27SaEhzyzuConlbbFmoM8KRmYOgyhQUemail@example.com> (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 <firstname.lastname@example.org> 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 <email@example.com>: > >> 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 --]
next prev parent 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_EmrKrvrXtJwWsydGhqy2aWxlBwD27SaEhzyzuConlbbFmoM8KRmYOgyhQUfirstname.lastname@example.org' \ --email@example.com \ --firstname.lastname@example.org \ --email@example.com \ --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).