From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id oCGzNYi61mIP0AAAbAwnHQ (envelope-from ) for ; Tue, 19 Jul 2022 16:07:04 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id ADeYNYi61mJtLwAAauVa8A (envelope-from ) for ; Tue, 19 Jul 2022 16:07:04 +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 22DF22A88E for ; Tue, 19 Jul 2022 16:05:39 +0200 (CEST) Received: from localhost ([::1]:60396 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oDnr0-0002LY-TL for larch@yhetil.org; Tue, 19 Jul 2022 10:05:38 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:43022) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oDnIk-0005TZ-PH for emacs-orgmode@gnu.org; Tue, 19 Jul 2022 09:30:16 -0400 Received: from mail-pg1-x52d.google.com ([2607:f8b0:4864:20::52d]:36471) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1oDnIf-00074U-DI for emacs-orgmode@gnu.org; Tue, 19 Jul 2022 09:30:14 -0400 Received: by mail-pg1-x52d.google.com with SMTP id s206so13485314pgs.3 for ; Tue, 19 Jul 2022 06:30:08 -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=K3halpJcrsyUo5wXFjp3b0uIsg2y7oYxgora2ClsCHI=; b=RYc+eL3kfCcyhK0Vd0ixDUvRVvYFlcIIecYKcJ+/2zmNZif/3TJTHM2o8X8Jxqb2rk qiFe4WjZxpO/eoDHUsSrzTgUJ52Wv9ABqCXRi8e724jIdGNJo6/zrecqDYzuOMDBXcXp dJv09XKb59fECUCx7BGLOLl50/03rrEH7Zj1/3I6cC/KWsLPRqhGQ/0O/iNaDfvYMXkz /YVm2tsrkUQ8CJsYepbHyqN4frJJ4ErFUK/EoKycMBgxoMQ4ISuuU5/hB7iKj3tPPOHl KX616/83I2LcfhHOdRhZy8c3M9drF1FEGtmA8i58kwdXhZ5yB7m4yXwZ0pISZcHjIVXY Q8BA== 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=K3halpJcrsyUo5wXFjp3b0uIsg2y7oYxgora2ClsCHI=; b=j+q1dqY4Q1uFmP5CfSfJcHifizL/w9AierJtj0mbUqfdjGA0K3jVaVzPNxmdpPpZUK PfZOXSaEDspDKKEOSmXSLwpCXno+Hr9ej+G8IFphx+/MNZ96c6wgkgiDwNtO+cCBG4nX JT4rpjIRP1KPmdPUQoa3E1Du7tTISQXHPqLZEwN0gL/7HijR98qB7WsOoAlp8xYUxHa9 cLd66Hrwc1BHwgUqmM5GLXIwCEA0tyoeZ6KnhqjiftIQyCK/1rc96ObRkFa3I9+i4AqK wE4Jm0369GyWcmNx/9TxaRy3u1nAnEsNWejTR5fLcTUkO+Gxu8iUz62TlH17d3+JcjvY 5Z9g== X-Gm-Message-State: AJIora/X4bYUt89aS3qgaf9flSQVGS9boeYszhd7xrdRQDb/tGJropDS o8Jjwf7cfmChEEe3QLYzjXU= X-Google-Smtp-Source: AGRyM1sh5aJUVS+GvKbsYU33hTLbzTd8Xz99p/NoV9soYqWFn/WRIzpMfzspdzwb7L/4GcLBc/PZyA== X-Received: by 2002:a63:2b85:0:b0:419:7b8c:ac58 with SMTP id r127-20020a632b85000000b004197b8cac58mr29144842pgr.230.1658237407888; Tue, 19 Jul 2022 06:30:07 -0700 (PDT) Received: from localhost ([2409:8a70:2b7:3fb0:8ec6:81ff:fe70:339d]) by smtp.gmail.com with ESMTPSA id e4-20020a63db04000000b0040df0c9a1aasm9847634pgg.14.2022.07.19.06.30.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 Jul 2022 06:30:07 -0700 (PDT) From: Ihor Radchenko To: Uwe Brauer Cc: emacs-orgmode@gnu.org Subject: Re: org-table with different conventions: decimals In-Reply-To: <87zgh6gb78.fsf@mat.ucm.es> References: <87zgh6gb78.fsf@mat.ucm.es> Date: Tue, 19 Jul 2022 21:31:11 +0800 Message-ID: <87y1wp44bk.fsf@localhost> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::52d; envelope-from=yantar92@gmail.com; helo=mail-pg1-x52d.google.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 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, 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=1658239540; 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=K3halpJcrsyUo5wXFjp3b0uIsg2y7oYxgora2ClsCHI=; b=FQJP6o+KKb0AhauKLsOwCBxnWOIjrNJtOu3GJOER0GI/iC9GT9J0mtHEWhxoAYCb9lZY0p ZGglztkYU01Vq3UQgeNB9rcM49P6oEHTZo9kpzmTwg0xMohTrDe7njimwI93ZogE+My2xJ 3ZVWRSJbX/fQQuMjUkGLvY7CcIDDii3O1GDt0WfCq+mAMQqokUGIQvriR3zX/e04LmnGuY KQkdVXFgWExbxcz1gKx1lXEBNSsfceUHPmblCOUR4iw1TIOyu0CQES9UcNocvF++NlcGAn aBXJofiGx05+ba/sWWG/nFSjukujqo+VLzohhlADHGY/clPJdQDdQovzcKvEnA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1658239540; a=rsa-sha256; cv=none; b=iAQAx+7L8SkxnIpKM8Yub4IWGLe76jSs8dV2Kg0tspLYd8/XSXUoPWZAUMJ7DRBddDPphi YUFATyVRSoEQfhqQADacVIX/k4pxdOQaXb5fzHIMQCmicVmRJrkiF/tqnXE0MHU22oDU8h CF69Iom3JHgIJ7D0Arb3bEHemu7Fin9GloIkFvQrAamcm6zro2pXJFeMp0Hhdzl/0bagmL NuRVVQOXGPzGwz+aHHBM1sXCevC9XYBIygObxeMVtA/wHEtCH/B0dPcZZKlbJjbKPXV5+8 dD1ISz9ArP2r/WT1+rMQnNUr4ujAwthBqXUAFlszm4fUIBeM0B6MTSY+Yx2xMg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=RYc+eL3k; 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: -5.43 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=RYc+eL3k; 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: 22DF22A88E X-Spam-Score: -5.43 X-Migadu-Scanner: scn0.migadu.com X-TUID: YSF3Y8M51MWf Uwe Brauer writes: > In my current setting, the following works > > | 3.5 | 4.2 | 7.7 | > #+TBLFM: $3=$1+$2 > > Now if I want to switch to the convention used in Germany (that might be > relevant if I want to export it later to csv, but this is a different > topic) does work in a strange way, any comments? I would expect > > | 3,5 | 4,2 | (7, 7) | > #+TBLFM: $3=$1+$2 > > > | 3,5 | 4,2 | 7,7 | > #+TBLFM: $3=$1+$2 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. Best, Ihor