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 ms5.migadu.com with LMTPS id mPlqK5yKkGLrswAAbAwnHQ (envelope-from ) for ; Fri, 27 May 2022 10:23:56 +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 SDhAK5yKkGLZNgAAauVa8A (envelope-from ) for ; Fri, 27 May 2022 10:23:56 +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 3DCD9FD4A for ; Fri, 27 May 2022 10:23:56 +0200 (CEST) Received: from localhost ([::1]:40458 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nuVGF-0001dM-Em for larch@yhetil.org; Fri, 27 May 2022 04:23:55 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:57254) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nuVEp-0001br-KE for emacs-orgmode@gnu.org; Fri, 27 May 2022 04:22:28 -0400 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]:45030) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nuVEk-0000zJ-Jt for emacs-orgmode@gnu.org; Fri, 27 May 2022 04:22:26 -0400 Received: by mail-pj1-x102d.google.com with SMTP id pq9-20020a17090b3d8900b001df622bf81dso3732479pjb.3 for ; Fri, 27 May 2022 01:22:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:in-reply-to:references:date:message-id :mime-version; bh=iMnH2AfsXx9CX2QCOP7sz1+IxQNiZHW3vknY08Cjpgs=; b=CZbUnet16/i3Onx7F3obLX+wkrEjBeUTDn0YOM75mjd3ggICL7LgEciXUTZZoCxr0O lZPO4xlMjJAaYAYhB0F81aTGWXUF/NBeIgK/+0tpAYUSVD1N+ArLHPTUjM878wCXwICR UOlfJtF5Y3qsUn3KNJnuDivlzOHwDHTIy6bkscXlEkoPjAxGLaC5hLCBLpMBd/y/BdNf AS07uPidEv6YCiqfGYaXjeAahw3eyxKQ0KUGMgq6c0d4V9LnHfx61J1VW8zmiimpqTYL 0P1B97BDhTPM4sfOZmKgZOgUYsgGTGswIgCtaP4lF7UbwW1PjLamA9loT1DMCFlea9xV tDLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references:date :message-id:mime-version; bh=iMnH2AfsXx9CX2QCOP7sz1+IxQNiZHW3vknY08Cjpgs=; b=jVQn+K7yyLcXt9yusGoa7RYdAvkMge4LItLE/+VCVhaEIwtd+eR+lIfFRgcijcwO8m EX4n57UaIMYrCLStSPNdMVv4ntYkwx0BA53dUdaBaWppt753+PhZIuz+WxBhDLvm+W9w BqRjLPiIK9SWhuY0beBk3vXNmL8qrvszhLCQ1djYpkX+YM1Y/yUTjdEYhvpm3ZDl8Eoj hDLTuKFhIH1VJCLx1m+SKq8xZxpfejPH3wiNNP3JzmRuR2w7QLYZV8FmZeK2Tg2pNDAv EVm1/0hoD0KjWuJKaD3l7OnV/TBTQdZM+kc/6LA1rZiqKPG7SOu78r3XjZOGVnK4NJRj Ma/w== X-Gm-Message-State: AOAM532SgfAH3lLZFA7p1SGodeQnDEB/D1xSfQEfGFD2/yBxRWQfiEHV HUVPqN4PNIApJbI5CmstBOU= X-Google-Smtp-Source: ABdhPJwBC3q8IsoVT5ch43lFImAuJdW802Yko4C5zvQc6BJgDKOtkzS5+kQXmCah6iTdQTJa1Sqx9w== X-Received: by 2002:a17:902:f688:b0:162:28c7:73cb with SMTP id l8-20020a170902f68800b0016228c773cbmr23592378plg.63.1653639741065; Fri, 27 May 2022 01:22:21 -0700 (PDT) Received: from localhost ([104.223.86.8]) by smtp.gmail.com with ESMTPSA id j13-20020a17090a31cd00b001d77f392280sm963549pjf.30.2022.05.27.01.22.19 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 27 May 2022 01:22:20 -0700 (PDT) From: Ihor Radchenko To: "Daniel E. Doherty" Cc: emacs-orgmode@gnu.org Subject: Re: Allow Currency Symbols and Grouping Commas in Table Numbers In-Reply-To: <87pmk0qdfb.fsf@ddoherty.net> References: <87pmk0qdfb.fsf@ddoherty.net> Date: Fri, 27 May 2022 16:22:54 +0800 Message-ID: <87a6b3gza9.fsf@localhost> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::102d; envelope-from=yantar92@gmail.com; helo=mail-pj1-x102d.google.com X-Spam_score_int: -17 X-Spam_score: -1.8 X-Spam_bar: - X-Spam_report: (-1.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, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, T_SCC_BODY_TEXT_LINE=-0.01, T_SPF_TEMPERROR=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" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1653639836; 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=iMnH2AfsXx9CX2QCOP7sz1+IxQNiZHW3vknY08Cjpgs=; b=IU08Iy0Bw/g6tREI3Vkin3z2NdSmj3WMBLSSveaZmzgPKRqEY+j1vGd95t7brNW2dLiHxN XTo2GfVjx27UJ9OajpcfoNTu7JV5H7NmjWJ8T7VPS3IMw/biKgcKscuMdHZbGNt5Et1c9h toyrM4PvnHHs55tFRQdwVPA9sKOIOtl7+gZU+9uHWjE8p4LSAYk/7nLFbob4j4SZE7p0qE KXI91mj0/G+Uz4vce4PlrDsXlxNFYXuXwaC2/R/pPmurLFq3zTd15K5BMeqLGpOYn3KkDW WjncT0mCcXqQL4L++naJXvBMw8LIb+uTUOX2zR5/SP/rGUlNaO7/n9UvYZ32Jg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653639836; a=rsa-sha256; cv=none; b=r6QYeeGGcCx6FjyRcrA2tFf4vlP4CLn/nApsA7FTgy3hncinNUgGWUSKAkdUp9aGyMoFFJ GtVgzKYQtXcmfQWmmNHHdjyEBy1jmFU0uiPI2X8LH+WTiupct6b8Sn2FMoLyUJ6u/VU1bZ OD5GRTle1uyZrhYiDDPsyeCeu/1IUrFZ1OIvD2bwMQnmBRQEX5ssgHFdpGPG5PtSd6Ns2u M2uOzCRDqnNamUFzuIUg7SjTXo3KoSDiCn9Q/gQINBlqZDGJczSEL3/ffpV5TW+fYoxQlm 4y8bPn46EcxB536thUXUkPE0fas/MERVPad61PFNZsRAAfNMuXn3SnpjKHxChQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=CZbUnet1; dmarc=pass (policy=none) header.from=gmail.com; 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.84 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=CZbUnet1; dmarc=pass (policy=none) header.from=gmail.com; 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-Queue-Id: 3DCD9FD4A X-Spam-Score: -4.84 X-Migadu-Scanner: scn0.migadu.com X-TUID: JLHJ7jOkT15H "Daniel E. Doherty" writes: > I often use org table to perform calculations and export those tables > to LaTeX documents. > > One thing I always wished I could do with org tables is get it to > allow numbers to be decorated with currency symbols, the dollar, euro, > yen, etc., as well as grouping commas so that the tables are more > suitable for presentation. You can, for example, do | 1 USD | 2 USD | 4 USD | 7 USD | #+tblfm: $4=vsum($1..$3) Emacs calc is able to work with arbitrary ascii symbols or even units. However, calc does not appear work with unicode. If Emacs calc were to support unicode, it would automatically work in Org. Also, you can enable latex in calc via (setq org-calc-default-modes '(calc-internal-prec 12 calc-float-format (float 8) calc-angle-mode deg calc-prefer-frac nil calc-symbolic-mode nil calc-language latex ;; <--- this is new compared to default calc-date-format (YYYY "-" MM "-" DD " " Www (" " hh ":" mm)) calc-display-working-message t)) Then, the following will work | \dollar1 | \dollar2 | \dollar3 | 6 \dollar | #+tblfm: $4=vsum($1..$3) Best, Ihor