From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id +5IAN6owkF+ecwAA0tVLHw (envelope-from ) for ; Wed, 21 Oct 2020 12:59:22 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id cMRDMqowkF99dwAAbx9fmQ (envelope-from ) for ; Wed, 21 Oct 2020 12:59:22 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 5E68C940717 for ; Wed, 21 Oct 2020 12:59:22 +0000 (UTC) Received: from localhost ([::1]:39574 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kVDi5-0001MF-7J for larch@yhetil.org; Wed, 21 Oct 2020 08:59:21 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:52302) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kVDhh-0001Lr-CU for emacs-orgmode@gnu.org; Wed, 21 Oct 2020 08:58:57 -0400 Received: from mail-oln040092074096.outbound.protection.outlook.com ([40.92.74.96]:60999 helo=EUR04-DB3-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kVDhe-0000GK-PS for emacs-orgmode@gnu.org; Wed, 21 Oct 2020 08:58:56 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=gK+W9Msmf4OEayTonDdywOfr14xNctzcGHqkfe6ISybzsvbe9d8lG5X01P3IxUGx0ciUPri6oqw62GvZ6ulq3iS5KPrgokc8YL7qLgkwYqHlneNyfaF2FIBFUkrP6pM0Li0wQypH6ytRISVGZdd2oybtOFxVvL+Tx63g6f4VGLeUb/JD2OCjKU29GChEJBBLJ2n0MZGmtWnoDVvF7NnaFKCVz0kybYBk4c68g4QXkooz31/QsOkEN5PUCgAdUaQIHEI6tAkJ3SsCEmGeOC9sqcoskJq4Ew0shZRh71qSLD9NYY5Uk/3RwxNhjuBAogoVcddz3+zdlok1lsjM8NuuOw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=1Vu47o1Fu+IWLSqdzY5aQUFK7hNk23qgAnY9P+wss24=; b=QTo/JdzA3mrJDOkneyf8KR884v06NJI20FokJ+VeZTSml/YButZs5F6TuLokHMMB08eVEiGpXXb6EIB+fNt5OBg5pgugP5Aao+YGC8kf5f/iqQGlGDKJTqZKVhEyneyDqtyQgiRMOPeHmpB4U0fkzk48SuG8Y2S01ESFw+dNjvnw0gq/584Sbo7FUXjdmuFVn4TyGkFCTIJ6sA6ACgPlmsSkrFVZ+TPjs0nh9wkn/EfBxmn1xW1opK5KyH413YJ2O4B439gjFlxFgqF0cjzL7jMGnDpDvRHe3Aa9eruxHxbYoQIkpEqwKLdhzCYKEpf+BUD4WQ1lVSOn8WhbbQlnhA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none Received: from DB3EUR04FT056.eop-eur04.prod.protection.outlook.com (2a01:111:e400:7e0c::48) by DB3EUR04HT221.eop-eur04.prod.protection.outlook.com (2a01:111:e400:7e0c::393) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3499.18; Wed, 21 Oct 2020 12:43:29 +0000 Received: from DB7PR09MB2234.eurprd09.prod.outlook.com (2a01:111:e400:7e0c::45) by DB3EUR04FT056.mail.protection.outlook.com (2a01:111:e400:7e0c::69) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3499.18 via Frontend Transport; Wed, 21 Oct 2020 12:43:29 +0000 X-IncomingTopHeaderMarker: OriginalChecksum:4FCA7BAE506E548C6CBDA03C2B1A9797D30F93AA8A38C9BDEE650EEFBCA6AEC9; UpperCasedChecksum:FB8A7DE11195756F8F557558222E0AA5176AA95BD3B4BA683A24D4DD3E893C16; SizeAsReceived:11174; Count:47 Received: from DB7PR09MB2234.eurprd09.prod.outlook.com ([fe80::453a:ee28:1eb2:b03b]) by DB7PR09MB2234.eurprd09.prod.outlook.com ([fe80::453a:ee28:1eb2:b03b%4]) with mapi id 15.20.3477.028; Wed, 21 Oct 2020 12:43:29 +0000 Date: Wed, 21 Oct 2020 14:43:27 +0200 User-Agent: K-9 Mail for Android In-Reply-To: References: Content-Type: multipart/alternative; boundary="----SN8X4RPRUS1HLF66Z6XWP8YJNAZ9HZ" Content-Transfer-Encoding: 7bit Autocrypt: addr=daniel.herzig@outlook.at; keydata= mQGNBF9+Xt4BDAC/p7qGCnhnTSxDcAKVw87taffomqJTpWHpSvdCQdpY3mwpG86V3G5Jel5Fqa6A M8QnWqpxQHoS10iSVIGgsObu28bnguVGVL39eauZTqwlcid17wykJfCgKTmCulqWA8LGVi6oa37m F6sZo9d9/ev1oE0xWqjRFaqhFh7oAG/A+lKDrdL3b9af4Jt0lNQQGinAmiPiru8vQckFDVj9Dd+Q 1f5B5JgAd3rMQxUbON54NU8ujgnEPQU9PrTH/hbjsaagO7PJmOECVmjdDWuwXMrFdYxJCUc5afbh iKin1ktncOXrX5rdI20XH8BxDOvlUvbUXMe/ERRw+G7e3+HOr91N8XmFlglwRDwvyrr1We2/507l OTkTz/KHtsH/CGfy7jjDOZ9eQDFGGR/VeCw+pqDGxm6xtRxZnrgHldqq3iLiUFT3mLR2r7gKa99s UiaEVMGDio7uFGF76bzHdzxpA4VIq0ldbdTrU/o41KMjSGCLKcQk7PSNnl0cBcj6mdraGwEAEQEA AbQoRGFuaWVsIEhlcnppZyA8ZGFuaWVsLmhlcnppZ0BvdXRsb29rLmF0PokBsAQTAQoAGgQLCQgH AhUKAhYBAhkBBYJffl7eAp4BApsDAAoJEAWn83RjJ5idcj0L/1Jt0HCKflsVIIS5wXvqoUO8wKjs EFvf0l2TCBvvCXsYEVCk2hi7NpUcNjuYHjzMjMh6vaoh8BZZYAIykgyAw++TRA1gu5Zmj614a8g8 JbXjMdTm/wE0OFXLlIwglmSdojtzILx1u/9WGTwfLnR39UcNe5H/+iyCAffiE+biukrBfDfjNlH7 zu0YQZppVxLCXpNHncIeL7/Jy1NzoR2o+fVtHLks8n2BIvUV1grfWgC2QGu4PaLKIDrcSPIpV09J B9QiN5/F+SbORAKdmMNXcIwzyEKlzbLCWfpm0OPpUi2LpFzP5EqmdPtRqs+GrfJmiXKXRgogB/a9 qN1EnxtGqIgGdwdb8UbwwCBcB/quCaVf7rBjdVe2SwplsBWAvepJuHntOWHSQHfTUE1kiUi5hTEj /Dw35OtwAGBCX/4SeT/lRJ7Ea/CyNf80VjsR7WVVqvVaNopJewVJNmycpzZgL33rqzHuOEQzciJe 3Synv+8MkQwVXkzHh58Ld1MjHbpUTbkBjQRffl7eAQwApbrvMeGOeqaEivzwXaHlAgPtYGSBPIlj SRBrO1cCCsFiLrOWKl0iZHRyFM4h5iO4UMX7o0Cv4uoHBN5ue73E8DM5Uovg8mvgZGMVUiP0fnUL zebFXf89SiXXAfSWreHUhajryyL+Xrh3VjyFQGIXW2nMw6lA8f8xWESay1a8+3GP07VM2+kbwye9 G1PO1NBD3Dslpvrid9B8H+wVjvHL2p9pfWyx8T8LflTirzsIUmpB/1o4Ms1r72wFriZaZEYKbRwu rqxGnG1kkXLuXcsb2mLZGDqTG9zRiOXK7XtM1mENl2PuEx4syHSHriD0UrGY2QEkUdLYXChYCEFY 0koT16N7HsbP2sx3pY6qQDdcaqJtKSyoxjOZVKMWyhDC0td1/Qn6GbiZxi/24pGO0GD7KK6avhsl Rk98d1bjeccvni/lHya1sA+QXakDuRI/mlLfC+gvcQxwVVvoORkWSuaOkzmBE9HYZe7mMv87Zo1n UkJERiD/TYhHgauxtvjkKhBvABEBAAGJAZ8EGAEKAAkFgl9+Xt4CmwwACgkQBafzdGMnmJ1/lgv/ WIXGhGHYj/EAqlkU5wPvijay/gJ9VgUZueHINO0tLpd+URysDpvuT0z92Z4MFm5mLsIGtoFJcIk0 LwcYMnQLVdKQdG+4W9XXGkUVWDpTS+q4L6WInCawjTKDXcGhnfJ7z3JR4Y/cNKVs9v9dInODkoGJ TElifl2ZgayeWVv5f0/akkSoqmrsK86vCq5mGlL0GvmiRGTt4R8FFzh8mLc49Fk4swsu1AEBirZJ 3Bv4kI6+OO8PYaerViHrKR4wJNlb7EyrQXGVXceZ7otMLNZqIKjDqBSZIW+uQAT8GJ7yvIEdbJNB IJzWe9O/Fg90hXgHtFQgERQCO8W912Bk28N0p8gUamdGmPxqwYBUMD6vpu2BpMo4YH2OKyYezaiA Cq4Q0rGYMUa6BWqfU/bwKCR/gVeQu76KpYt2UH/wzDhFGRc9CcIYRrOmlmvRt8QmT2BwHgkZQPDp PbzUtiV//NWoLIHl+r0KMfiXuUlpReiZGOId4wtQyMMBQYdV/ElPTxvJ Subject: =?UTF-8?Q?Re=3A_Bug=3A_Can=E2=80=99t_assign_to_hline_relative_reference?= To: Dante Catalfamo , "emacs-orgmode@gnu.org" From: Daniel Herzig Message-ID: X-TMN: [NBLD6JhEs5eVLV70fwz3TkJiph5zhhrI] X-ClientProxiedBy: VE1PR03CA0045.eurprd03.prod.outlook.com (2603:10a6:803:118::34) To DB7PR09MB2234.eurprd09.prod.outlook.com (2603:10a6:10:41::11) X-Microsoft-Original-Message-ID: MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from [10.206.67.62] (213.142.96.78) by VE1PR03CA0045.eurprd03.prod.outlook.com (2603:10a6:803:118::34) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3477.21 via Frontend Transport; Wed, 21 Oct 2020 12:43:28 +0000 X-MS-PublicTrafficType: Email X-IncomingHeaderCount: 47 X-EOPAttributedMessage: 0 X-MS-Office365-Filtering-Correlation-Id: ad6f2c75-165f-4ae5-55ca-08d875bee929 X-MS-TrafficTypeDiagnostic: DB3EUR04HT221: X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: UEiSh4/lYVT6SOxOhhqtOSl4v9rmPUx9jJuAHGIN4q8Rp8JRmPr1o5kk593TnOjrbX2SiVTwHSScYvgCkJ7dE2iYVd93Nf17srcu+tB6aHN4yl1dxHkR+ENqDUtmuVSnhunVHai5S+cGrlkKtMy1VbW4ssHTry5V3PdcSzbb0NT5CBvfTxmg0dBxQujuR25YwTxRhEDL1sum4yv5E85eqzGasQEEM7oBCPvppefrPEhhLSsNG2Gx3Bus285VVvDx X-MS-Exchange-AntiSpam-MessageData: pbprOVqHdJyn08kzVn8Q4dVrg3GxcQ3ThjXMSHXO8NAb+zS1NvzfDczeIqfhJNcqPShpRiNOM7dVFBnqrfWLWwaQODTkGoUS6xSEtrkNoX7+Gs5FAYyO4XC40WyN/R5fGw1Fh78/VF5XiCaRMR8hug== X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: ad6f2c75-165f-4ae5-55ca-08d875bee929 X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Oct 2020 12:43:29.3888 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-AuthSource: DB3EUR04FT056.eop-eur04.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: Internet X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB3EUR04HT221 Received-SPF: pass client-ip=40.92.74.96; envelope-from=daniel.herzig@outlook.at; helo=EUR04-DB3-obe.outbound.protection.outlook.com X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/21 08:58:52 X-ACL-Warn: Detected OS = Windows NT kernel [generic] [fuzzy] X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=outlook.at (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: 3.39 X-TUID: 83xNqiNH/li4 ------SN8X4RPRUS1HLF66Z6XWP8YJNAZ9HZ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable This seems to be related to: https://emacs=2Estackexchange=2Ecom/questions/= 15185/cant-assign-to-hline-relative-reference There seem to be restrictions regarding hline-relative-references within t= able-formulas=2E If change 'I' and 'II' for 1 and 2 on the very left of the formula, it wor= ks (keeping the other hline-relative parts) =2E If I stay with the former I= get the same error as you (emacs 26=2E1, orgmode 9=2E1=2E9, Debian stable)= =2E I hope this can help,=20 Daniel Am 21=2E Oktober 2020 03:14:10 MESZ schrieb Dante Catalfamo : >Hello, > >I'm trying to create a table where the third column between two hlines >is set by a formula referencing the second column=2E > >Here is an example: > >| a | b | c | >|-------+-------+--------| >| row 1 | 12=2E00 | 144=2E00 | >| row 2 | | 23=2E00 | >|-------+-------+--------| >| sum | 12=2E00 | 167=2E00 | >#+TBLFM: @I$3=2E=2EII$3=3Dif($2 !=3D 0, 12*$2, >$3);%=2E2f::@4$2=3Dvsum(@I=2E=2EII);%=2E2f::@4$3=3Dvsum(@I=2E=2EII);%=2E2= f > >When I try to calculate this table however, I get the error "Can=E2=80=99= t >assign to hline relative reference"=2E > >Why is this now allowed? This seems like a fairly mundane use of a >table to me=2E It is explicitly disabled in the source, but without >explanation, and searching the mailing list doesn't turn up many >answers=2E > >Is there a recommended way to handle a situation like this? > >Could this feature be fixed? > >Thank you, >Dante --=20 Diese Nachricht wurde von meinem Android-Ger=C3=A4t mit K-9 Mail gesendet= =2E ------SN8X4RPRUS1HLF66Z6XWP8YJNAZ9HZ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable This seems to be related to: https://em= acs.stackexchange.com/questions/15185/cant-assign-to-hline-relative-referen= ce

There seem to be restrictions regarding hline-relative-refere= nces within table-formulas.

If change 'I' and 'II' for 1 and 2 on th= e very left of the formula, it works (keeping the other hline-relative part= s) . If I stay with the former I get the same error as you (emacs 26.1, org= mode 9.1.9, Debian stable).

I hope this can help,
Daniel

=
Am 21. Oktober 2020 03:14:10 MESZ schrieb Da= nte 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 |
#+T=
BLFM: @I$3..II$3=3Dif($2 !=3D 0, 12*$2, $3);%.2f::@4$2=3Dvsum(@I..II);%.2f:=
:@4$3=3Dvsum(@I..II);%.2f

When I try to calculate this table however=
, I get the error "Can=E2=80=99t assign to hline relative reference&qu=
ot;.

Why is this now allowed? This seems like a fairly mundane use o=
f a table to me. It is explicitly disabled in the source, but without expla=
nation, and searching the mailing list doesn't turn up many answers.
Is there a recommended way to handle a situation like this?

Could t=
his feature be fixed?

Thank you,
Dante



--
Diese Nachricht wurde von meinem Android-Ger=C3=A4t mi= t K-9 Mail gesendet.= ------SN8X4RPRUS1HLF66Z6XWP8YJNAZ9HZ--