From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id SCfbI+4K2GLHFAEAbAwnHQ (envelope-from ) for ; Wed, 20 Jul 2022 16:02:22 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id uDnHI+4K2GIqUwAAauVa8A (envelope-from ) for ; Wed, 20 Jul 2022 16:02:22 +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 57BCF29918 for ; Wed, 20 Jul 2022 16:02:21 +0200 (CEST) Received: from localhost ([::1]:36140 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oEAHM-00021x-4O for larch@yhetil.org; Wed, 20 Jul 2022 10:02:20 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:43720) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oEAG1-0001kk-Di for emacs-orgmode@gnu.org; Wed, 20 Jul 2022 10:00:57 -0400 Received: from mailer-211-152.hitrost.net ([91.185.211.152]:36181) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oEAFm-0007hh-Tm for emacs-orgmode@gnu.org; Wed, 20 Jul 2022 10:00:49 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=christianmoe.com; s=x; h=Content-Type:MIME-Version:Message-ID:Date: In-reply-to:Subject:To:From:References:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date: Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=OiK7nWup0uerrtM92bcHKpqujIr49x1M+CTa39Ayx9U=; b=Sulojykwd4nkay4P790EsV80Zx CpML3EtnHFW3wkgH9V0Gr9wnlIa4TLjt6x08O7c3CC2tFBQW2FvhzDqoFgboT5M3j7O9msLFVxD3u Ys4zgbaOdeeoKGxL7Ho3rtr5omDIqve2SlLmuqIP2exCIZh6OuHjkRhzgcqySaMUq/KcNm57CX6p9 69qcFwOH9bYCWb6awvzgGa2DhumFnzmKmZXX/zNB48OkIsj/bXCH1BB13oAp87BiANMvO2cEuEUAz jHnupU93cMM7qHFPLxQ/ryosMR+N7B3DONLnoVZDcyXkJUJu1K+ClFbsZRJqjUW+Zuvc6PdJ5pfyI 8a87jFSA==; Received: from [193.77.114.89] (helo=Tauriel) by b1.hitrost.net with esmtpsa (TLS1.3) tls TLS_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1oEAFb-00D8eC-24; Wed, 20 Jul 2022 16:00:31 +0200 References: <87zgh6gb78.fsf@mat.ucm.es> <87y1wp44bk.fsf@localhost> <87fsix6uaq.fsf@mat.ucm.es> <87fsiw4gke.fsf@localhost> User-agent: mu4e 1.2.0; emacs 27.2 From: Christian Moe To: emacs-orgmode@gnu.org Subject: Re: [feature] Allow "," decimal point in table cells (was: org-table with different conventions: decimals) In-reply-to: <87fsiw4gke.fsf@localhost> Date: Wed, 20 Jul 2022 16:00:31 +0200 Message-ID: <87wnc7zxxc.fsf@christianmoe.com> MIME-Version: 1.0 Content-Type: text/plain X-GeoIP: Country [IP], SI [193.77.114.89] X-Antivirus-Scanner: Clean mail though you should still use an Antivirus X-Authenticated-Id: mail@christianmoe.com Received-SPF: pass client-ip=91.185.211.152; envelope-from=mail@christianmoe.com; helo=mailer-211-152.hitrost.net X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, DKIM_INVALID=0.1, DKIM_SIGNED=0.1, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=no 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=1658325741; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=OiK7nWup0uerrtM92bcHKpqujIr49x1M+CTa39Ayx9U=; b=sKp241d/5Epyeen3UB+yAHJs27NsjD9eJb90vxCysiSs9Po5SyncBm6BCLbworECKnNKkj qViRIFPMRCGiRX/CmAsgakwpC9A7aOL2WV2OoUvFdPPELMxFrGR4kcWPqUJdjFtWCqdesg mDcI6IxG6BRSzvyG4XnIO7wk6CishrE3JwB/OaQUeEfc8ymIXIic1IujvZIfzS6maU5O5g Rfog4mLY/VUnkmHTTENczE2AomjyikEjrmr2dwKlDug/+ZXmBN4zSvqM6+2NdFoVWQDviY lDxzaiF/6QBGOMPGoCMkv+0KdaHC7hnKD7bbygthQEUu8TLnk3gpxo+cIydxfw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1658325741; a=rsa-sha256; cv=none; b=luGbeDTws6hp2RFXSYM0EbrWXqjBiANgHlQoQjK9H7C6LJMurgdZLeZvS6q7erCQu8StZo suWdo4IcBdxKEd0Hd1MaCIPxVyvmkXaKX36GIZRq84P8/5etCoOx7SRcwJ/Sekap9Xmf2l msQpW1OHzxLHNBq4H/HwfuNZPQg6K/mojqUENgjmS23IQNYFNsDFxYL4IOCw6NQtO35PH+ GHufyIg3iUQnlFp/lgRn3Xf0aBhtr2/8Z7bdaCa2NQBFQy1za/WLpb7uftQcmJSom/ysaJ z18Sg5kyuvmwQlTFsSZqRS+BzUneK56nUOlb5lddZpDr2FY7Z5Ti4XOTlOFcng== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none ("invalid DKIM record") header.d=christianmoe.com header.s=x header.b=Sulojykw; 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.53 Authentication-Results: aspmx1.migadu.com; dkim=none ("invalid DKIM record") header.d=christianmoe.com header.s=x header.b=Sulojykw; 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: 57BCF29918 X-Spam-Score: -2.53 X-Migadu-Scanner: scn0.migadu.com X-TUID: XyKZfj07BzBi Ihor Radchenko writes: > Uwe Brauer writes: > >>> Uwe Brauer writes: >> >>> Org tables use Emacs' calc under the hood by default. >>> AFAIK, calc is unable to use "," as decimal point because it is reserved >>> as a vector separator. Which is why you got the vector addition in your >>> example. >> >> Thanks. I was afraid that the issue was with calc not with org-mode. > > Note that you can instead use Elisp formulas. See 3.5.3 Emacs Lisp forms > as formulas. It is more flexible. > > Alternatively, we may implement the comma separators as a built-in > feature. Org table formulas already support notations like > > | 3,5 | 4,2 | 7 | > #+TBLFM: $3=$1+$2;N > > or > > #+TBLFM: $3=$1+$2;E > #+TBLFM: $3=$1+$2;L > > (see 3.5.2 Formula syntax for Calc) > > we may as well implement something like ";Nc" that will interpret cells > as numbers with "," as decimal point separator. > > Is there such a demand? > > Best, > Ihor That's interesting. I remember an earlier discussion that settled on the recommendation to keep the spreadsheet as it is and use export-hooks if one needs to change the decimal separator upon export. My contribution to the discussion also gave Carsten the idea of starting a Worg page called org-madness.org. :-). Thread started here: https://lists.gnu.org/archive/html/emacs-orgmode/2011-05/msg00551.html But I don't think we considered the possibility of a flag to make Org translate dot-separated decimals into comma-separated ones for Calc. That could offer more fine-grained control than export processing when you need some dots to stay dots. And it would certainly be less challenging for users who just want things to work without digging into advanced export options! Export processing (which has since become more fine-grained with the introduction of filters) remains an option, though, and some backends offer further possibilities. Yours, Christian