From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id oJvuDMvJb1+rNwAA0tVLHw (envelope-from ) for ; Sat, 26 Sep 2020 23:07:55 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id ID24CMvJb18OeAAAbx9fmQ (envelope-from ) for ; Sat, 26 Sep 2020 23:07:55 +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 B45529401AE for ; Sat, 26 Sep 2020 23:07:54 +0000 (UTC) Received: from localhost ([::1]:41430 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kMJIH-0005RF-O3 for larch@yhetil.org; Sat, 26 Sep 2020 19:07:53 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:41036) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kMJHt-0005R8-VC for emacs-orgmode@gnu.org; Sat, 26 Sep 2020 19:07:30 -0400 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]:40197) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kMJHs-0000Tk-3o for emacs-orgmode@gnu.org; Sat, 26 Sep 2020 19:07:29 -0400 Received: by mail-ed1-x534.google.com with SMTP id t16so6179779edw.7 for ; Sat, 26 Sep 2020 16:07:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=AruRUEaCuLYbzrgAuGoaWBWVi7DvbQyifj0xrJbY7G0=; b=USWw+mub1nLq3N745QSvmuJCJfbdPxwZnKzweY2CrpMF1rXIg0rT2zte52P0Jz1Hsu R6I2nYkCHLhGRsP2e2QT0bo/r0n6KafBjLBYxcwyI1kU5AQFcEP6myTkWzeZ1HLCklcg jEpz9axCDUaFIzdCysBBPmwpGKlvp9tS1Gnz1g43qz/17r68Retr48K0x7Pdc9Cqph43 qdgQZAj5KlC40inLhjJAtaHl9Hf+gwZsotLBvlqtVVFXyfmRK0VxhrWxvYSRv9OcTOQj 9TWGAwSMh63IPQm9lWOigIjqkYzVqYWS7Pvc+Nr/z3Q3zNAM73Eb8zWdAj2JpHg6/UBs ONbg== 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:date:in-reply-to :message-id:user-agent:mime-version; bh=AruRUEaCuLYbzrgAuGoaWBWVi7DvbQyifj0xrJbY7G0=; b=QPaNHN1RB5nMU2um4rqwOH64NSnSIW3RTbshWr/zGKiz+79kD43c6qFu9v0eVQxa+Y O037b/Y/otrnYSEF/2x+c/WAXHfjuXybJBRnkiZH82BvjxatDCPmIG0Ecw5fEaRXITpo X/IcUKH7jR8ZquApYDIC7ovGrVldD/fx0AKKD4paz26OOAc82mImU+eofHnSdYBdTbG/ maQhjiHEsP+Fz98d6dMZLuGEmEwR+yTcZKeeFZd1ApYThRMUY0M31GXkY6LsX6DxBskJ /wwdQ68qOxbxx56GptVQEk0s7EvHTrRAjTli42VXSVaAJxOiPuwhrMZH5ukDw1Fr/7cE 5vtQ== X-Gm-Message-State: AOAM533gfe3ujj8Gz/rh+YgfyqD1eH/y/MQdciB2BdfNU9f7Q7FV9LI9 vY4z/BESUz+SdKRH3KmxLAs7sPF8fIg= X-Google-Smtp-Source: ABdhPJxnBsIAFJEvwDE6HW3EP1BHv73dDiGWYWhLb/cM1bTSHp8+G+UPmfsFp4txTCSqU2ppfixFHg== X-Received: by 2002:a05:6402:2d9:: with SMTP id b25mr8614273edx.131.1601161645847; Sat, 26 Sep 2020 16:07:25 -0700 (PDT) Received: from freegnu (24.183.22.109.rev.sfr.net. [109.22.183.24]) by smtp.gmail.com with ESMTPSA id t10sm5482050edw.86.2020.09.26.16.07.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 26 Sep 2020 16:07:25 -0700 (PDT) From: Jeremie Juste To: Robert Pluim Subject: Re: org-table-sum References: <87a6xex5o1.fsf@kyleam.com> Date: Sun, 27 Sep 2020 01:07:22 +0200 In-Reply-To: (Robert Pluim's message of "Fri, 25 Sep 2020 10:59:42 +0200") Message-ID: <87blhsyw5x.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::534; envelope-from=jeremiejuste@gmail.com; helo=mail-ed1-x534.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=fail (rsa verify failed) header.d=gmail.com header.s=20161025 header.b=USWw+mub; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); 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: 0.09 X-TUID: ZKvwHz2fjv9v Hello, Thanks for the input. >From what I understand, it seems that org-table-sum is not behaving as expected. I don't know if it would be interesting to split the function into 2. One for summing of time values and one for summing integers? For the sum of integers (possibly real numbers) it might be interesting to make a function use TBLFM directly? Best regards, Jeremie On Friday, 25 Sep 2020 at 10:59, Robert Pluim wrote: >>>>>> 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 > -- Best regards Jeremie Juste