From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms1.migadu.com with LMTPS id 0DArEARpTGZEdwAAqHPOHw:P1 (envelope-from ) for ; Tue, 21 May 2024 11:27:32 +0200 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id 0DArEARpTGZEdwAAqHPOHw (envelope-from ) for ; Tue, 21 May 2024 11:27:32 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=hb15B4tL; dmarc=pass (policy=none) header.from=posteo.net; 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" ARC-Seal: i=1; s=key1; d=yhetil.org; t=1716283652; a=rsa-sha256; cv=none; b=DcLql8LSqgQZu4Yyo8onMlcZ7lfvelGCPm3DxuP0OZu9+S8jD+FEXHrB7LMIKwX8lE0/wE Ggpk4dZjRUH+RgfWyXaSw+BGaWSmonCqZ7/VYHysDg4j4fpZQkaLXjp3PHnFSwebYtJINU 68s0XYjt6Kuw1eRtHq7UjXCPscQLrSPXathZ0TqeR1yXpfCijXm8RynM6QQhtozKZnvwyt /Eq7yrIIHRBF/vqNGMZH5uQvvZ2NVHivXiog8ZKTc0c07rNF3xzMC+RXy7O18X5gBbR8tU h2KctBjYDvFJiC4SWI8xORoZE29TmmxLR7ooqmltfEYZD0r16mElD6jBtOFyvw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=hb15B4tL; dmarc=pass (policy=none) header.from=posteo.net; 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" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1716283652; 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=wHPSdP62kXNcbJqdWz6/bp9KZf9D+i4m+WYYHSmwpno=; b=Lh5ZCRwgEPNQPPd02OysEQ5n0qLF9UxWOAsKBiy325dJijJUdTcCrBOOjVYxeQgxopanMQ O0NwVDyQXaq9MsBK0X4scWqHaS3vFYtkq+vf5FHvDeDKFOfboDmIP6X5ZdLEIMqtQ0n6Xc 5UjyJwIBrktrQHGK5cL6nO9vtBAIWaKSNQyqoA4ZNIlvSEYrVHo9l0vI2XAEdXfCADT3jv S1ipcxLvUbAL8I9knW6ZrFQhDDeli9kNAOV0moZvoaVBeF60gz2SsGgND0tpGHOvpMLAXA 94DPXaLgeGnpMU9hcIgWFuyGcxan7gzkzafqp8JANIjdL0Gn5O9W1TBAcpCiZw== 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 273BC23836 for ; Tue, 21 May 2024 11:27:32 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1s9LlV-0005V4-N8; Tue, 21 May 2024 05:26:37 -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 1s9LlU-0005UY-7n for emacs-orgmode@gnu.org; Tue, 21 May 2024 05:26:36 -0400 Received: from mout01.posteo.de ([185.67.36.65]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1s9LlP-0008AR-9D for emacs-orgmode@gnu.org; Tue, 21 May 2024 05:26:35 -0400 Received: from submission (posteo.de [185.67.36.169]) by mout01.posteo.de (Postfix) with ESMTPS id D5A66240027 for ; Tue, 21 May 2024 11:26:27 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1716283587; bh=VDpc72yi5P/kBsRoeyRQT/THea+a+bKZ7yQcx3IFh7U=; h=From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type: From; b=hb15B4tLT3CILnJBkM6oIM0iImCAJM5raYZ3pv5CwgMkw/pExtaRL5fKNtzTPh6Ei Qjuk//S30ERr1aFM0QvMPtV0MQOFLfj+WgBBH2AuNim3zPE7CDZOxgl+OZj+5Xc8Mb 7N1D2Pt7JFN4nT9GawZcoK8Syb72x/Qz+MeERs5zCmAGHMa1kuYEpFlq3hQOsLpz+G ouLuuQ5R3FQ9LW3Xnlj0GLXlCu5RdSKmiHbOz9lgKYmEkAouTlcOpRLI/waNIkWBql W2aaxCHgE4xpoNAYBsatl9VfqxvvhlxJtmPaN7bDnxnyQaRu/oY1tddN3NfFod9Hvi W+NZDFpyQQA6A== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4Vk8Fb19XZz9rxb; Tue, 21 May 2024 11:26:27 +0200 (CEST) From: Ihor Radchenko To: Nick Dokos Cc: emacs-orgmode@gnu.org Subject: Re: [BUG] org-table-eval-formula mishandles semicolons in formulas [9.7-pre (release_9.6.14-1019-g5092ec @ /home/nick/src/emacs/org/org-mode/lisp/)] In-Reply-To: <87ttiu3vj8.fsf@localhost> References: <87sf32ceid.fsf@pierrot.dokosmarshall.org> <87ply5v1gj.fsf@localhost> <87ttiu3vj8.fsf@localhost> Date: Tue, 21 May 2024 09:28:11 +0000 Message-ID: <87r0dvpl90.fsf@localhost> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=185.67.36.65; envelope-from=yantar92@posteo.net; helo=mout01.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 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_MED=-2.3, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=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: 273BC23836 X-Migadu-Scanner: mx12.migadu.com X-Migadu-Spam-Score: -9.46 X-Spam-Score: -9.46 X-TUID: jUuzLMgKilEe Ihor Radchenko writes: >>> #+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";") > ... > Fixed, on main. > https://git.savannah.gnu.org/cgit/emacs/org-mode.git/commit/?id=5af062511 Alas. We cannot restrict what to put after ";" in formulas, because it can be interpreted as format spec for `format': | a | b | percent of a in b | |----+----+-------------------| | 10 | 20 | #ERROR | | 20 | 30 | #ERROR | #+TBLFM: $3=($1/$2)*100;%.2f%% So, your example #+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";") is actually ambiguous - it may also be interpreted as ") format specifier. You can solve the problem by putting an extra ; at the end of the formula: #+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";"); I added an example explaining this caveat to the manual. https://git.savannah.gnu.org/cgit/emacs/org-mode.git/commit/?id=6799350a8 | 1 | 1; | #+tblfm: $2='(concat $1 ";"); | 1 | ") | #+tblfm: $2='(concat $1 ";") -- Ihor Radchenko // yantar92, Org mode contributor, Learn more about Org mode at . Support Org development at , or support my work at