From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id GJZbMqDK3mY87wAAqHPOHw:P1 (envelope-from ) for ; Mon, 09 Sep 2024 10:14:57 +0000 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id GJZbMqDK3mY87wAAqHPOHw (envelope-from ) for ; Mon, 09 Sep 2024 12:14:56 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=rensoliemans.nl header.s=soverin header.b=BV76bUvg; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1725876896; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=J1E0uBpA1CSRGJOvPMJ8jLhr3RF/TdaywUbprLMxzG4=; b=gLGgZiBlmnzeopnyLvak0cB2hINTA11kx7O4Fm2gnPfbPhpmAZV1WHBfUtgNqnTkubw0kG vSph+Bv8mVSwpVL2rlOnPhdLpzV0aobr45ZxPxjMg3VdTo7wfGITrUl8JhBEz+aEy7GgLF pFbxRWxQooS4oHulrH+0sBdru6CVNc/AaxBne5jspEowTToclNMYmdlj9vAzgIjfCJazuY i3aAfMbJPrcA4W2CO7x+zztzRsFISOjiL2cWJzrTyJ1QJH+ahI+QhxpiYS7Vnrp5ypEHas Kgi1hjJ7nkv/oMiGMutcI86Xmt+waYhzEmvd3cwlbyReu9rf+y8/eHwVS9SaAg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=rensoliemans.nl header.s=soverin header.b=BV76bUvg; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Seal: i=1; s=key1; d=yhetil.org; t=1725876896; a=rsa-sha256; cv=none; b=I9gzjZyXlBTlnCFz9QKgdzQvs+jhmckoeKhCiY8L6dFrevJUm6wN5zEEglOVQejSUfLGPm wcdp2MbWQNAWGSUOFiZ7rs578SseahAQjuZHy0cVuA5Kv60vowD04ZJFw88miPm9/Dz/ac OUYR8sxH0a8oJr9QEOV/aZgLT8wzHlk/91lIPoIP1Vnu7/m7mhHvirba89krnqgzTd/AkP OpqS8FmG9nxImd7yK+OD71zAYvzLomEdCBXblYhxQXs6XHbo9218YydWpLPr5/X/tEDRLz sCQfr3A0MVAP2xjDd6eGdSEYr/dwrFS1CgJ/tXO1ixyCSFCx90JtLHlsypn7nQ== 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 86B8B12164 for ; Mon, 09 Sep 2024 12:14:56 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1snbP3-0005oR-69; Mon, 09 Sep 2024 06:13:49 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1snbP1-0005oB-EL for emacs-orgmode@gnu.org; Mon, 09 Sep 2024 06:13:47 -0400 Received: from outbound.soverin.net ([2a10:de80:1:4091:b9e9:2212:0:1]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1snbOz-0000dh-6R for emacs-orgmode@gnu.org; Mon, 09 Sep 2024 06:13:47 -0400 Received: from smtp.soverin.net (unknown [10.10.4.100]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by outbound.soverin.net (Postfix) with ESMTPS id 4X2N2W3q5Zz7J; Mon, 9 Sep 2024 10:13:23 +0000 (UTC) Received: from smtp.soverin.net (smtp.soverin.net [10.10.4.100]) by soverin.net (Postfix) with ESMTPSA id 4X2N2W1KH1zHS; Mon, 9 Sep 2024 10:13:23 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=rensoliemans.nl; s=soverin; t=1725876803; bh=k0v5NpYo3Kpq0qKKHhDaaszyxRGbCYKOzBW7o5oLDZ4=; h=From:To:Cc:Subject:In-Reply-To:References:Date:From; b=BV76bUvgl6yqicIXicGVem9FbUeg7kIClQByBtF1hoq0RiBw6M3ry6FUFYi2/ZJf9 LSyKTsLpzqXuEGJ9r6bsJEUWFJosNMBfzHFoQsALgX9LI6nQC9kHPQQ1NzcAc9SBny DlVrL1toQ5oOXLmuv+/U2BAZywZShHj8Q8SvcsWidtaofi0FRYhd3PbveyfoHBcaay dSA2sqF3N4tU6VBM8/MtR0bTKTDu9ejrsJIojdLUM7g05JUGd31TcY7XEuTJijUAT5 I4vvSsIL+2PrKOaiQGYeA7Q+UNQcY59ZxjjtElYi61MBUyM654kTZ+CyrpVxiZijYy dp9nzYSC8PWIw== From: Rens Oliemans To: Ihor Radchenko Cc: "Fraga, Eric" , Emacs Org mode mailing list Subject: Re: strange behaviour with $PROP_r1 value in a table In-Reply-To: <87ikv7eo6v.fsf@localhost> References: <87jzfqjsyr.fsf@ucl.ac.uk> <877cbpce74.fsf@rensoliemans.nl> <87ikv7eo6v.fsf@localhost> Date: Mon, 09 Sep 2024 12:13:21 +0200 Message-ID: <87wmjl6sou.fsf@rensoliemans.nl> MIME-Version: 1.0 Content-Type: text/plain X-Spampanel-Class: ham Received-SPF: pass client-ip=2a10:de80:1:4091:b9e9:2212:0:1; envelope-from=hallo@rensoliemans.nl; helo=outbound.soverin.net X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_LOW=-0.7, 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.29 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-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Queue-Id: 86B8B12164 X-Migadu-Scanner: mx13.migadu.com X-Migadu-Spam-Score: -4.59 X-Spam-Score: -4.59 X-TUID: Mo4PaYuYeFer Ihor Radchenko writes: > I just tried > > #+property: r1 0.96 > > | value | 0.96 | > #+TBLFM: @1$2=$PROP_r1 > > followed by C-c C-c on TBLFM line, and I cannot reproduce. Indeed, when simply executing the formula nothing goes wrong. You highlighted it below, the "problem" occurs via `org-table-formula-from-user'. > I _can_ reproduce via C-c = -> `org-table-formula-from-user'/`org-table-formula-to-user' > where is it a result of the default value of `org-table-use-standard-references' The same for me: I can reproduce via 'C-c =', or via the formula editor in the cell (':=$PROP_r1'). `org-table-use-standard-references' is interesting, I did not see it before. >> - (while (string-match "\\<\\([a-zA-Z]+\\)\\([0-9]+\\>\\|&\\)\\|\\(;[^\r\n:]+\\|\\> + (while (string-match "\\(\\$PROP_\\)\\{0\\}\\<\\([a-zA-Z]+\\)\\([0-9]+\\>\\|&\\)\\|\\(;[^\r\n:]+\\|\\ > This is doing much more than fixing the reported bug and might affect > valid uses. I'd rather fix the bug (if it is a bug) explicitly, without > risking breaking other things. Hm, looking at the manual ("(org) References"), a constant of the form '$PROP_Xyz' will be used to search for property 'Xyz', and it seems like a bug to convert 'Xyz' to another format in this case. The only use-cases that are affected with this change seem to be when a table formula starts with '$PROP_' and has a spreadsheet-like reference after it, no? Perhaps I am wrong: I searched for the usages of `org-table-convert-refs-to-rc', but perhaps I missed something important. Do you agree that it is a bug, even with `org-table-use-standard-references' set to `t' or `from'? -- Best, Rens