From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id iHdOCNSoYmTxyAAASxT56A (envelope-from ) for ; Mon, 15 May 2023 23:49:08 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id wKlwB9SoYmTumwAAauVa8A (envelope-from ) for ; Mon, 15 May 2023 23:49:08 +0200 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 343DA3B318 for ; Mon, 15 May 2023 23:49:07 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pyg3B-0000aE-64; Mon, 15 May 2023 17:48:13 -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 1pyg37-0000YQ-E2 for emacs-orgmode@gnu.org; Mon, 15 May 2023 17:48:09 -0400 Received: from sonic311-27.consmr.mail.ne1.yahoo.com ([66.163.188.208]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1pyg35-00023R-Nl for emacs-orgmode@gnu.org; Mon, 15 May 2023 17:48:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=att.net; s=s1024; t=1684187279; bh=EfOEBlkX5iW21r1s4IX54QtibxTRAP5Vkb0Ks8f1RF0=; h=From:Date:Subject:To:References:From:Subject:Reply-To; b=osO65daNIasUz3E/qnbVsblyvCFr0thS8qyXiJv7KbWXTKwgVECrfHp4jmP+cwSpSUP5SiqVPNBcsAMdZNrY8eVT5HvsoCoaYnFUSniG4PV96+mrt5+FK4HWTFloPjlO/FvyvcatMbf+Nx9F95o0IvUK7eQZqLnoEK6RCSNMwuM= X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1684187279; bh=Gsj9ZChSacuLNRmks10eUrtmjBNnbrbgwoqwQYfdSbx=; h=X-Sonic-MF:From:Date:Subject:To:From:Subject; b=LoCu4+qKM+2TSZ4UIPNHYuVrr332ZsCp8cSpVAqk6zyEYv38sZSx5rY8hPIpxSnD6aamJ7ohoNXsGCAfNTJXytKaYNr40B0oTE217KA5MKXXoJYorJEnCSQz8va9WjSRNT96uwbKWqHrsD/OI3QvXODu+LVgrZxrI7NeUIs+TGspazRoImyzEcYyiMdQhUvNSU1oyewFOn0g9zvKmXxgqMmU0rl1XuYd/nT6b6Q2EYSOXwj9BSuGdApzE1LYTnveTGIdITK0XgCs6kYRBHnijpVXebTW9DkopiYppE1Qh1Bkp5Q2L0pT42nENqv1JRnTqMK0UFnnTITxl92Wu1EiDA== X-YMail-OSG: dFSsiLUVM1mp0WB50QUM.jf35X82q.6NsWe0sjS2RaWwDTFRBMlyDuZbU1HNUF6 .ULJ.qGGVdZcnAj3kzeoqli4tUuQcNEF5e55QK35J6UIJPSrikrzu4YgE3tPBAquk20JuTOrTatg Ec2yVuqHWsp8IBDpEbII6ii9Kg73xeKg74kSBVj7uPDokQBsFJwVdIQBc5oZvH1GbMtmguaqF9sW .6Mm9jE2FIsxjJqghCXfrodifnc0hTJwAo1BjJNpMEQeOeOhFjco.AGlJ7rUVQhcS2uihOnElmyo hYUaMnUDOjERCcpJbDh6zdvg0tFgFLJP3vIyzX7dEaratmWyJUOkMJLSLwUQs5qTLovScYAIy4R1 Q4dzUDC2OanqF0I2ES0PMuC5IbYaWk.oFWSli9ykEGrHUesFRMViz4zFR6_7GJUHmJLRLbQdroL_ xkOjdMXicfgCa12uOsIy77R2FVfmGY7h8rNqDj7oa_JD6Kl.6f0S7hGViNUyaD3iGExcoS3GvaOa hrqg1aSOcsh1zzRzWDCnnq9FB.s088pakPiv5zX71g0jYYA_qNx.mNGOZQTEfHq4YJE6ky3iPc3t GrBl1W650ihoYd67UKt56VGj76RJQ7hc6hXRi_BAY0MHSnoHiYLAxqQdMn7IzeetvtTDZQS0hRKI fMb5mwSnMGY4WH5VxgY7ybw3TVitFU6v13V5llbYWKddWzl1goGz2qfaAnS5BIouSR7yNDHiKqkp NuyyCXolTuC2tKwo4ajqAF6gfAGe7PkbU0eatFi0VSTIPVEUVZKnk6r29bjQ58CglYFNCt.UocYv uBCcZxRF0NKpE9UvcgZAi0C6OQaWwwm7eOzuYGeH_35cREAqI4oYbX84imJU5dTDAcbOZfGaAajl 8ihtKmHoW2akCUwM8rr.5lWD.jtpEYtv9l6Z_DHSLMjJTAGdtZbIo8Nhl9lSGVPxcENAMVN71c8t ZJWmKJk51d6oMzLj1NQJJLzql1R6NjSQMzWdCUpOCXiHtC2ADQAexPzM0B8mvqtBYG9OJioFpPzd ri9LuVhAcTJGkOem2OPsjRIoDjv4ulKErQKXGeAQ2oBO.UzTOUl_F7iFhSn6yVzixb2.0grW59AE a.L8jEep.pB9U06vQcgdbYYEwEF88CISMhbV1gb2HlFAR5laKRmT1ZnnyOjEvOyStoA5WxOMVsCw bSdOk4fsm408p7vffZw2kM6I__HR3A_ytVxFZTXsuivtap.CQwPJEhOSnp.AZk2KjTb4vORBNNXt FiZXUgnrFbgRI_nXsP2dTsYjNAid_LP17Q37onFv7Qa1ABI6QF1Vvspn0DkImq6M86nPuBK74jJm MlqD0v.X3OHec8oRGBobtQR_AMD74p0MneCx_i_9qUuGvT1prAe_2EIJ7UHraTkoBDxOFvFcn8jF xBEuT3nLeYx9uXjPPSg2L6H4Kbt_gb1DbMVwJDFgOpom2T8KvERpPdRF10IF1FwIHO1.LI2pGV4V gdaGtyrmuy8GA2bYObZ3VfgQnX5kUZP7tsSvPPatgtgh.ovdYnmVdin75.hWPEURli2p.nPQwNfJ 2qxaqOb3wAGd9WXRgH6tvfU0QCHb01c1pdyH6kb8U3glqZoCSg9RTq555pGQEbUGrf.gpGZdSuod YK7N.9rhM8k5MqyCjexSmOzfgE4N_iv5WszGyb9blMULWQDphY1rVhP6454Ec1DJd6W.p9IqcYR0 bMgBXku2Skmm.muTkBMTACOItw_eGhxDPcFlV4fozxxnJv2Ma_ivBe66nQVvIPGyXxIpQxSZ9g9k SlyR9kf298E1f7eN8EA5P_QxR2HMnpD3c9tMw.hnAAEZw3O4cnOmYuQt9_CJeEBFa9etwapXfIwg de_BMgkge0iB4j9ybn8hXkfZk1kjj0Ei_05leS2hLMpI5MdWt6LMt_0w4OFSTmAga9YRgmSS0jYS ZaNFzw6eYiNiBe90hm8N45R.bUqQT4iROan9hHY4fcfF16zfcmSLQEF9Re1Mbbex7XN0V9NRLmdK qQiZlUN3QnoFww2Vv5la6meHdsXWkCI_VJEsFLpsC3iHsL2TAQAAxBUJjAX5Fa1mi1b1av9etS1m v2CpFxsosJrd8Vu0cyEMK4Bfd90cT2mQRYWkNyZElxxcu91NYebjUvf_MW7xkoX8SnXQs5PBi448 FyZdRiw8PA_ehCVC4hcWFHXWaXke9oYppLOH.br3ZUHKYPkZ5QSFmN1SwGhYDWeACar0WPZ5NgAl c5_yWxxf2q.ITi6iJbkTZGKdWTsn7y00- X-Sonic-MF: X-Sonic-ID: 164b0fb6-5377-424c-98b1-5c0bff8aa43f Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ne1.yahoo.com with HTTP; Mon, 15 May 2023 21:47:59 +0000 Received: by hermes--production-ne1-574d4b7954-hz4nw (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 000b46d70ffea2a8b37948aeb5e18e36; Mon, 15 May 2023 21:47:58 +0000 (UTC) Received: by mail-yb1-f179.google.com with SMTP id 3f1490d57ef6-b9a6eec8611so761643276.0 for ; Mon, 15 May 2023 14:47:58 -0700 (PDT) X-Gm-Message-State: AC+VfDyUBMxBrQmCj0QMU5Y7jZ6JYR3EUTGZ1+Ofp8y1xag8BhcmTtcf RoIftVcjUOdemPVh0aB5wo9Ety/1iY8k+AavW7M= X-Google-Smtp-Source: ACHHUZ5Q5W1tU/OGfeUkEh828tE5RrYirNH+EwVeCk8Mm2pGlORYKcavFTYFtk3Rmx9axkQG8JgoPhkvf3djcMHDN7A= X-Received: by 2002:a81:1e8b:0:b0:560:d022:53ac with SMTP id e133-20020a811e8b000000b00560d02253acmr15823006ywe.5.1684187278119; Mon, 15 May 2023 14:47:58 -0700 (PDT) MIME-Version: 1.0 From: Jeff Trull Date: Mon, 15 May 2023 14:47:47 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Formulas on table cells containing '$' To: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="000000000000729d3505fbc2685c" References: X-Mailer: WebService/1.1.21471 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Received-SPF: none client-ip=66.163.188.208; envelope-from=edaskel@att.net; helo=sonic311-27.consmr.mail.ne1.yahoo.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_NONE=0.001, T_SCC_BODY_TEXT_LINE=-0.01 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-Flow: FLOW_IN X-Migadu-Country: US ARC-Seal: i=1; s=key1; d=yhetil.org; t=1684187348; a=rsa-sha256; cv=none; b=I/XXiWV1FWYSR3wsJL4yVGRzhWV53KBr32UpDGxXe479VXHn7KC7/GR4suc2u8iAeXCVNZ 0J8sBKdOn16DlC09mteSzWIaEhPcGhxaPR5VLqbFIDlsToYMyJSu8de0kT0PbP0IZC+ahS MvH2arAGr5qD7sVcjGNLDnaquabNt6cfk2Lh5vPSHWeqwuqdzyy3Q52U9omp/6S3i68HDI spuEDqPSfbHMxT8v/jbTWiaZkBhI8fx8mWXjuqRnJ8BmjKU0M8qTloYIgpsBMxNfvztrX+ w22Z+OMEDHVkD8urPEuyfqAwKHVnSe4d7EJJhF2WCWPAeCUrMQ40cUKOt3WuJQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=att.net header.s=s1024 header.b=osO65daN; dmarc=none; 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=1684187348; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=EfOEBlkX5iW21r1s4IX54QtibxTRAP5Vkb0Ks8f1RF0=; b=dKOvY2Gx9rfz6O6StA9WbV0Gns4V7miB7sJPkhmSie08kuFjl592uSJ5uNO+mh6v0PBSgQ uNKmMNsc5Pvf6msS1EuPNxRB4bmuXBi/a2ObjbFG/d4yvgfLzdzmRf/t8FGKtko/Gdpxfd Pe4cQB2yVeTmn5KY0cYzJPr5aPyzYTREpmsq1Rcwum3xoSBJ03R0XRJN7u6WiA89XKmSlt A36pyqyK2t8rHBkiqEKwMRf+x08eCo6ComzzEuAi7hjCNGoQMFYZXUybhaanWwcWuHAI7N m9tuU1NjeyOUSMd+jIgDOphPKzSTPQQxQQOuq1GQMMmOzJCok6UMQzNeTaNeJA== X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=att.net header.s=s1024 header.b=osO65daN; dmarc=none; 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" X-Migadu-Spam-Score: -4.40 X-Spam-Score: -4.40 X-Migadu-Queue-Id: 343DA3B318 X-TUID: z/bI3MpAx4CH --000000000000729d3505fbc2685c Content-Type: text/plain; charset="UTF-8" While investigating an error executing a table formula I discovered that cells containing '$' cause column references to be executed even when no attempt is made to evaluate cell contents as code. Here's a simple example: #+TITLE: demonstrate strange error in currency column | 3/1/2023 | Deposit | $200.00 | | 3/13/2023 | Interest | $1.13 | | 4/1/2023 | Deposit | $301.22 | |-----------+------------------------+---------| | | Number of Transactions | | #+TBLFM: @4$3='(length '(@1$3..@I$3)) Evaluating the table formula produces a 'Invalid field specifier "$200"' message. In more complicated examples you just see a #ERROR in the cell. With formula debugging turned on, I can evaluate the expanded expression with no errors. This is surprising for a number of reasons: 1. The formula makes no use of the cell contents 2. The formula debugger notes an error but actually shows a valid expression 3. Columns with currencies will be fairly common esp in imports from financial institutions 4. This error happens before the formula is evaluated so there is no chance to remove the problem character in the formula as I do with the commas ',' which are also present Is this by design? If so, I was unable to find any documentation explaining it. Thanks, Jeff --000000000000729d3505fbc2685c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
While investigating an error executing a table formula I d= iscovered that cells containing '$' cause column references to be e= xecuted even when no attempt is made to evaluate cell contents as code. Her= e's a simple example:

#+TITLE: demonstrate strange e= rror in currency column

| 3/1/2023 =C2=A0| Deposit =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| $200.00 |
| 3/13/2023 | Interest= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | $1.13 =C2=A0 |
| 4/1= /2023 =C2=A0| Deposit =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| $301.22 |
|-----------+------------------------+---------|
| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Number of Transactions | =C2=A0 =C2=A0 = =C2=A0 =C2=A0 |
#+TBLFM: @4$3=3D'(length '(@1$3..@I$3))

Evaluating the table formula produces a 'Invalid f= ield specifier "$200"' message. In more complicated examples = you just see a #ERROR in the cell. With formula debugging turned on, I can = evaluate the expanded expression with no errors.

T= his is surprising for a number of reasons:
  1. The formula ma= kes no use of the cell contents
  2. The formula debugger notes an error= but actually shows a valid expression
  3. Columns with currencies will= be fairly common esp in imports from financial institutions
  4. This e= rror happens before the formula is evaluated so there is no chance to remov= e the problem character in the formula as I do with the commas ',' = which are also present
Is this by design? If so, I=C2=A0was u= nable to find any documentation explaining it.

Thanks,
Jeff

--000000000000729d3505fbc2685c--