From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id WJgcJT6ybV/UHQAA0tVLHw (envelope-from ) for ; Fri, 25 Sep 2020 09:02:54 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id IPLvID6ybV9bbAAAB5/wlQ (envelope-from ) for ; Fri, 25 Sep 2020 09:02:54 +0000 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 90972940981 for ; Fri, 25 Sep 2020 09:02:53 +0000 (UTC) Received: from localhost ([::1]:50762 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kLjcy-0006bZ-4Z for larch@yhetil.org; Fri, 25 Sep 2020 05:02:52 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:54564) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kLjZz-0005Kl-Fo for emacs-orgmode@gnu.org; Fri, 25 Sep 2020 04:59:49 -0400 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]:51468) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kLjZx-0006Qn-RE for emacs-orgmode@gnu.org; Fri, 25 Sep 2020 04:59:47 -0400 Received: by mail-wm1-x332.google.com with SMTP id w2so2247675wmi.1 for ; Fri, 25 Sep 2020 01:59:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:gmane-reply-to-list:date:in-reply-to :message-id:mime-version; bh=WK9T8fk7BRSJxnF1EH0Dj6GsFrP1z1XyWyuU+lUhzDs=; b=iSdNhc7s3qDr7A6lcpixKlyWT1EO/8Zsoo96OxS3C+MlysuSEyVkR3MdasO21ul4sm Krr4/axxiC08QyqDlgsTZrKHtLupDHtNkPoWshM5/4kNowdS09OnQkw59L5cMrcYjFVA xBvp3bokLc9Og4n1ARmhV++OlQ8yc7bU3sv5wX8JmWu8AOl9RZd2xFpoETe5vu+w42Sf JNrDNum0AV2FivAlK3CZaKVEE4fkZaAYiPySof/HQMce7qJiA8aQpUPzwuA9QLpdyoYh BRlNwx3QdOvX8c+H78RORRWg86jlS45kI590ipO1g2Dt/dPINoLqeyc92mrVhsSKSPio 4DMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references :gmane-reply-to-list:date:in-reply-to:message-id:mime-version; bh=WK9T8fk7BRSJxnF1EH0Dj6GsFrP1z1XyWyuU+lUhzDs=; b=OfJPYH0Lo/N/Zj84IvxyX7Wg0w2e+8dWUu5Cl0nfzxEvDXbimbiOR2ndMP4n1JDL+2 3lacxo24KD8PfyTC1QmYO1b+3y8HxxCYfPSAYX14SCFOlwG7HjFA43+qq28S6SqB/fcL Lq5Cm5bt+y23BcNU8J2tX6UamZGau8GsmP0edojT5VWyqNqOvL3HJVwQIDWbVI3utv3x Zc8DIuvL7v307/OOlqNNGucgOiTCLUu7Ez9eUQvYuHuNMEkd799iecqwVUyXpF1pOVqW hSVJ3QMc2K4sbAhSYLC+YhrR9kXf/xvJeRBXFeEGIyCOneRTYeOeL9wqvd7iJub/Q3Is OVDw== X-Gm-Message-State: AOAM533itigRLWybLB/8Zxe1HNIcQU8sE4mtlB5xeYBtS2l7uKaOLay+ qC4+L2n4nXR87OyomEkX1Wckwdtmy98= X-Google-Smtp-Source: ABdhPJxubyCaI+lKf+KzWqA5m4FMY3JTWc5l6worvXCPmjgLcUMASWOiUj4iwKizcPoBXq3Y1ujA/Q== X-Received: by 2002:a1c:bb06:: with SMTP id l6mr2051194wmf.175.1601024383778; Fri, 25 Sep 2020 01:59:43 -0700 (PDT) Received: from rpluim-mac ([2a01:e34:ecfc:a860:4dea:e838:932:4b32]) by smtp.gmail.com with ESMTPSA id t203sm2140008wmg.43.2020.09.25.01.59.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 25 Sep 2020 01:59:43 -0700 (PDT) From: Robert Pluim To: Kyle Meyer Subject: Re: org-table-sum References: <87a6xex5o1.fsf@kyleam.com> Gmane-Reply-To-List: yes Date: Fri, 25 Sep 2020 10:59:42 +0200 In-Reply-To: <87a6xex5o1.fsf@kyleam.com> (Kyle Meyer's message of "Thu, 24 Sep 2020 16:48:14 -0400") Message-ID: MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::332; envelope-from=rpluim@gmail.com; helo=mail-wm1-x332.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. 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, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Kein Test , emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=iSdNhc7s; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.71 X-TUID: z6YMeL80/Aza >>>>> On Thu, 24 Sep 2020 16:48:14 -0400, Kyle Meyer said: >> I did not find a way to reproduce this with other numbers, but the >> order seems to matter. Kyle> See . Exactly. Which is why you should use 'calc' with floating point numbers, it handles them correctly. i.e. | 171.00 | | 4.07 | | 4.44 | | 2.61 | | 12.21 | | 6.69 | | 19.72 | | 23.09 | | 6.23 | | 15.28 | | 250.00 | | 250.00 | | 250.00 | | 78.85 | |--------| | | #+TBLFM:@>$1=vsum(@1$1..@-1$1) Put point in that empty cell and do 'C-u C-c C-c' Robert