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 GKh+Auraj2IA2wAAbAwnHQ (envelope-from ) for ; Thu, 26 May 2022 21:54:18 +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 YBVWAuraj2LjNgAAauVa8A (envelope-from ) for ; Thu, 26 May 2022 21:54:18 +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 9275741305 for ; Thu, 26 May 2022 21:54:17 +0200 (CEST) Received: from localhost ([::1]:40100 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nuJYm-0003ti-HD for larch@yhetil.org; Thu, 26 May 2022 15:54:16 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:36476) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nuJXK-0003kT-Gq for emacs-orgmode@gnu.org; Thu, 26 May 2022 15:52:46 -0400 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]:36382) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nuJXI-0000Ry-T1 for emacs-orgmode@gnu.org; Thu, 26 May 2022 15:52:46 -0400 Received: by mail-oi1-x22b.google.com with SMTP id u140so926224oie.3 for ; Thu, 26 May 2022 12:52:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ddoherty.net; s=google; h=user-agent:from:to:subject:date:message-id:mime-version; bh=2/f4Rs4JtI9JO2hvoKHoCcX+mk3rAl1RWbBdfJT07Ck=; b=eiFM3yWbN9wkY50J/hckRdu/gDofibrhpn0gZDuhs70DQs031jwzSAKBbu5rSH+yPR Dns15XbskhEYTy1iMCeCrzhaQIyNTjRGG8c0ZUhOoy0LTgYjfqRykHtq9J2K25RHKDCl K9uLz2JJMz3daMuQT5Txx8mHQ/3WTEZr+85D4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:user-agent:from:to:subject:date:message-id :mime-version; bh=2/f4Rs4JtI9JO2hvoKHoCcX+mk3rAl1RWbBdfJT07Ck=; b=Snh50gMDaEwlQlRFGQk7qpaef3/aotgVt8GP5Rd70/RMuhrNZnG2BrEZEb2zPMCLZ6 i76vfqHisj8PEOhzUMGScjmf9Eq5uza1HyyVfc+sSOvSCahEIayVCy1Ephs5tWCUp6ye 5IKL59qOR2q9W/aU6XlmmaLA0hAKyTYu3XrGShvmI4I4PpY1KkfEXYO3J4FQP2B6hci1 w0dBRFoP4AFexSTYh3ou/2D7cL4q2lTQkIWhJ5MNKEijHhQ4Sqb/RUDsvGq2KnTz+a8K HjuNZBLYPRUnpPaFEwp3RgklL2lnEtPrpk2eLrSxgeq0M8OMOntcBOypJ3jnTMWoHejX bG7w== X-Gm-Message-State: AOAM533fYH1XHUhiuy1vXJW+baEa6Iddvq+PoWnDL8GfHqxD4F/O8ERp 8KsfAJxqc2jQI25w5R/yaE+zlKjLAQ/CyA== X-Google-Smtp-Source: ABdhPJw69ct9TcnGcFO9nKGyijVTdR4KT8QQLJJWH8CXteb5XYZKr0yLmSqnr7CC3s2iCCG/4aSFZQ== X-Received: by 2002:a05:6808:15aa:b0:32b:7fab:3722 with SMTP id t42-20020a05680815aa00b0032b7fab3722mr2187387oiw.19.1653594761544; Thu, 26 May 2022 12:52:41 -0700 (PDT) Received: from micah.ddoherty.net ([76.201.154.172]) by smtp.gmail.com with ESMTPSA id t25-20020a056870601900b000f1b1ff7b8bsm21147oaa.51.2022.05.26.12.52.40 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 26 May 2022 12:52:41 -0700 (PDT) User-agent: mu4e 1.7.8; emacs 29.0.50 From: "Daniel E. Doherty" To: emacs-orgmode@gnu.org Subject: Allow Currency Symbols and Grouping Commas in Table Numbers Date: Thu, 26 May 2022 14:40:56 -0500 Message-ID: <87pmk0qdfb.fsf@ddoherty.net> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::22b; envelope-from=ded@ddoherty.net; helo=mail-oi1-x22b.google.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, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-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" 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=1653594857; 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:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=2/f4Rs4JtI9JO2hvoKHoCcX+mk3rAl1RWbBdfJT07Ck=; b=F2nknfL5f4HzVR7pWR0+UtPcUj4Opz03QBB4V9itQWLkE1QfcjbTmLBeqMdsy7+OGRc4kn RmQZmhc+1K+/ifKUprQngsm65ukdqOnCpFi5bvmcE+OZdWo+6V/X+DuMP25VEQb/gILiV0 aV2mtt7egrs76u55Y4XH2r08XBO7XsmCHudopRRh+2I5rAt+x0pvGP44X1wNlrw0k4rhuv 5guMGM5OG58g9flVNZ3keTzFA4ipD5kGeb1+KDZwAsIC0OPnugpRH5yZHSA1lu7WjXg+r5 oYPsNtHyMDyNzZenBfkM9sJ9V0xNEW9NSX6DAXzbdSrdqeoA6//Xzd9pGTrPZA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653594857; a=rsa-sha256; cv=none; b=k/ogFeWhFKsap1P6EoGDrAdvCTvqtAFl8lBB+i/FRR9VtTakBSQ1+xmnUdfEW+z5Zy61Eo G9g5hfMQ6Z7BaE4Ipg8De3AIRAVWN9KNdYcgsExUpWs6mdfCCaIXAnw0uRTindhAkT9Nvh SRcVOcRaYBaYWh9ceqnPP4F5YMLZVViHy3foCHwHz6TYDEz6+VTodvkp91sDCfA7HW1R4F aCm5XDSYBkScOljDGi8JJwPcFikijDQjLFQJox1AcMTt6XJeVibSVBtRL9Z6oXDkCHrzjF tu5CE4Kw8+ctDlXRC1+6u/MhTXn+Lks4TKu/uaNgiHENRvSKUhHQzQvDES0/QQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=ddoherty.net header.s=google header.b=eiFM3yWb; 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: -2.04 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ddoherty.net header.s=google header.b=eiFM3yWb; 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-Queue-Id: 9275741305 X-Spam-Score: -2.04 X-Migadu-Scanner: scn1.migadu.com X-TUID: Xq33Px3FpYId 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. I can see from the code that there is a function, org-table--number-for-summing, that converts text into numbers for summing, and it would seem it could strip out leading or trailing currency symbols as well as grouping commas before submitting numbers to calc for calculation. Consider this a feature request. I think it would be a very popular enhancement to org. Regards, -- ==================================================== Daniel E. Doherty Law Offices of Daniel E. Doherty 7300 W. 110th Street, Suite 930 Overland Park, KS 66210 913.338.7182 (Phone) 913.338.7164 (FAX) ded@ddoherty.net