From mboxrd@z Thu Jan 1 00:00:00 1970 From: Russell Adams Subject: Re: recalculate tables Date: Thu, 25 Aug 2016 18:19:34 +0200 Message-ID: <20160825161934.GC4165@cardamom.adamsinfoserv.com> References: <87mvk12iu7.fsf@luisa.c0t0d0s0.de> <20160825121227.GB4165@cardamom.adamsinfoserv.com> <8737ls29g0.fsf@saiph.selenimh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:58440) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bcxNk-0007xz-6e for emacs-orgmode@gnu.org; Thu, 25 Aug 2016 12:19:57 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bcxNh-000838-0X for emacs-orgmode@gnu.org; Thu, 25 Aug 2016 12:19:56 -0400 Received: from brown.tulip.relay.mailchannels.net ([23.83.218.23]:62251) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bcxNg-00081h-08 for emacs-orgmode@gnu.org; Thu, 25 Aug 2016 12:19:52 -0400 Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id B8249120C05 for ; Thu, 25 Aug 2016 16:19:46 +0000 (UTC) Received: from kefka.asoshared.com (ip-10-229-2-62.us-west-2.compute.internal [10.229.2.62]) by relay.mailchannels.net (Postfix) with ESMTPA id 1EA9E120029 for ; Thu, 25 Aug 2016 16:19:45 +0000 (UTC) Received: from 5ed25635.cm-7-3b.dynamic.ziggo.nl ([94.210.86.53]:2469 helo=localhost) by kefka.asoshared.com with esmtpsa (TLSv1.2:DHE-RSA-AES128-SHA256:128) (Exim 4.87) (envelope-from ) id 1bcxNS-0001Gc-LR for emacs-orgmode@gnu.org; Thu, 25 Aug 2016 12:19:39 -0400 Content-Disposition: inline In-Reply-To: <8737ls29g0.fsf@saiph.selenimh> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org > > This doesn't update either (C-u C-c *): > > > > |---+-------+---+---| > > | 1 | derp | 3 | 3 | > > | 2 | derp2 | 5 | | > > |---+-------+---+---| > > | | | | 0 | > > #+TBLFM: $4=$1*$3 > > > > I'd been working with these recently and discovered sometimes it > > wasn't updating... I hadn't gotten an MWE though so based on yours I > > composed a few. > > It may be related to the fact that the first row group is considered as > a table header. Column formulas do not apply on these headers. See first > paragraph in (info "(org) Column formulas"). Excellent point! That fits the other examples as well. I thought the header required an extra character in another column to trigger. I frequently use horizontal lines to trigger calculation using the relative range for lines above the current cell, like so: | | | | | |---+-------+---+-------| | 1 | derp | 3 | 3 | | 2 | derp2 | 5 | 10 | |---+-------+---+-------| | | | | 13.00 | #+TBLFM: $4=$1*$3::@4$4=vsum(@-I..@-II);%0.2f Perhaps someone knows a better way? ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3