From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:306:2d92::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id MCYPGBEcFGV4jAAAG6o9tA:P1 (envelope-from ) for ; Wed, 27 Sep 2023 14:12:01 +0200 Received: from aspmx1.migadu.com ([2001:41d0:306:2d92::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id MCYPGBEcFGV4jAAAG6o9tA (envelope-from ) for ; Wed, 27 Sep 2023 14:12:01 +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 EFD5C5B349 for ; Wed, 27 Sep 2023 14:12:00 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=iWVu4tjB; 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"; dmarc=pass (policy=none) header.from=gmail.com ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1695816721; 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=VFksm+XZ+EEby8kfdyfMYDemzyI5GNsDL6tDH6jh7y4=; b=dspiTDrMHs7ctIRviqYTYWqIqcqClguvXFuQ2Gdp5kqAry+PCbNyg3or9pQpA4W4ns0QMT 12V0FATAFR0EiTbvfWiFofvchcF7W1hd3U44reM8krFX3YN5WGi1uZRFSuwvuDQSvfN7+Y wWMeGoJRDt2Eqfx32KFZL5g7ILVG/XaL5ULYTmfBEbgROjF2sb1tFn27IqOMrIvBHVozpp AhTY5RQd8OewKt54px+PzV34IbWu+fcoDEul6oyklmQqawXKHVIjOvDAvJjjUNqn+fKfSQ 1rajJbYICuBj/pWIlJmaFyJuCjArT5h/KXBQNjfSVitkqhwsU+R6dig9MYjodw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=iWVu4tjB; 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"; dmarc=pass (policy=none) header.from=gmail.com ARC-Seal: i=1; s=key1; d=yhetil.org; t=1695816721; a=rsa-sha256; cv=none; b=j87c322O8iF0H5HL7bT6tMMGnJZNsJAfKxeNYtHANWdgW1877jJ6CrFHWMdXt1b11uD2pW qF3sS2XeB+8QM74fd0G1xM1hpcx56CRg3Sam6uIuoifJko/YcxIHc0V62vgZYKMh9aqIzM NQu24PGhCrz6zYC6nznPvDmD0FpGR03Kg5bqIp3lFnVkrJ8oBJ/heAdBbZ81Ztodpmk+sT +zE0O/1bRjhZI9S+JF7pnnF2TvRa7pIFWFhiTGZLjyvBIP7c5K+pbJ8nIUUQdO2A8/ZaID MXpSV3FncD0Vp7w7gLunEgGrM4/AEvlyvplfNmix7dnVle/qR5tOmnw9xU4pow== Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qlTNZ-0001by-3d; Wed, 27 Sep 2023 08:10:57 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qlTNW-0001Xg-9w for emacs-orgmode@gnu.org; Wed, 27 Sep 2023 08:10:55 -0400 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qlTNM-00032A-LC for emacs-orgmode@gnu.org; Wed, 27 Sep 2023 08:10:54 -0400 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-40594697600so58706555e9.1 for ; Wed, 27 Sep 2023 05:10:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695816640; x=1696421440; darn=gnu.org; h=mime-version:date:references:in-reply-to:subject:to:from:message-id :from:to:cc:subject:date:message-id:reply-to; bh=VFksm+XZ+EEby8kfdyfMYDemzyI5GNsDL6tDH6jh7y4=; b=iWVu4tjBWSs++iPanw/fKkSNnBUsySbDhwB47V16oAH6hIObNJImlherjZCfVIXqkR h81Rs56C1guojFIicJJHIevzHCMVNkTzW24ve3KsPXMgnmuv0mfC1B3hCFw+c7vXMH+1 /VWA3t2+Yys6nDivu/zwqTrnO2foT54y0pf39wFEvMWPJngovNQv1fJ8ebeewmrON0mj q0qEsBZKc3HfY504LF/dv5yPQyhIzKkyhjG8tA2SqJXKfl/skudG9B6Yrz/WhtnE2t/4 rCZPblZCg/37n5GXX3a/hf3ErZTY0qzF1JbZXP8oPEgYY8By5O23KHQOVBi3jd+Cv+eq Y0Tw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695816640; x=1696421440; h=mime-version:date:references:in-reply-to:subject:to:from:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=VFksm+XZ+EEby8kfdyfMYDemzyI5GNsDL6tDH6jh7y4=; b=qnFEsOgTjbQnakGvD13GrkCXX2cV1WKqpFGS4wYRl3q1NEyxJd+OIEAoM6LKoY8ieY wQ6auzbeoncfWF8GLAUOCfZzdnX6XDNmcp3ixGguW+s/rSi70kryQEzuFD0XBj9iPkrU JscAlrZqay4JD4i45poU0Aj11ci4Oe/i8HoT/XT+juOPj38Vi8CAjCjhD49G07RCDy/P SeIth/xFEw0Px79Z7hPP0rnBOxYikPCFdqR5XMcGj6uZK6hPMDXhhPicmNSjJNwXpa2S 9qqjnl+8qcOjo2DYkhSDnfGOXbsbyFgLGDzBCXlQBJLllmomF6poMCVFh6GO2RE90UiV k+Bw== X-Gm-Message-State: AOJu0Yzawiv57OgMMmdfvOBG+cG61Lc3rfDct95YuQ351EdlBJSqniag WAuNdSw9zvE73K2xFpNCiy6BPL+ksyg= X-Google-Smtp-Source: AGHT+IFijywFSGk8LdnjYcnVG7UuaTh3FrKbShz1T0ANMQAXr72uP8IMzQyBYHCKpKScvCdLBWmk7A== X-Received: by 2002:a05:600c:114c:b0:405:770b:e90a with SMTP id z12-20020a05600c114c00b00405770be90amr2060625wmz.34.1695816639754; Wed, 27 Sep 2023 05:10:39 -0700 (PDT) Received: from keynux ([2a01:e0a:505:3460:169:7511:f49a:58eb]) by smtp.gmail.com with ESMTPSA id v20-20020a05600c215400b00401b242e2e6sm14961180wml.47.2023.09.27.05.10.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 27 Sep 2023 05:10:39 -0700 (PDT) Message-ID: <65141bbf.050a0220.b1f34.e135@mx.google.com> Received: by keynux (sSMTP sendmail emulation); Wed, 27 Sep 2023 14:10:37 +0200 From: Bruno Barbier To: Paul Stansell , emacs-orgmode@gnu.org Subject: Re: Named columns in org tables [9.7-pre (release_9.6.9-797-g4d0f89] In-Reply-To: References: Date: Wed, 27 Sep 2023 14:10:37 +0200 MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::329; envelope-from=brubar.cs@gmail.com; helo=mail-wm1-x329.google.com 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, MSGID_FROM_MTA_HEADER=0.001, 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.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-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: -8.49 X-Migadu-Scanner: mx2.migadu.com X-Migadu-Queue-Id: EFD5C5B349 X-Spam-Score: -8.49 X-TUID: loQ9aHB5KgHt Hi Paul, Paul Stansell writes: > Hello, > > On this page https://orgmode.org/manual/Advanced-features.html > it says > - '!' :: The fields in this line define names for the columns, so that > you may refer to a column as '$Tot' instead of '$6'. > ... > |---+----+----+----| > | ! | c1 | c2 | c3 | > | # | 1 | 2 | | > | # | 3 | 4 | | > |---+----+----+----| > #+TBLFM: $c3 = $c1 + $c2 > > Is this a bug? It seems to me it's a bug in the documentation. Currently, column names are not allowed in the LHS (Left Hand Side) of the formula ('org-table-get-stored-formulas' assumes it). Although I'm not sure why. In other words, you'll need to use the real column number for the column that holds the results. This should work: | ! | c1 | c2 | c3 | |---+----+----+----| | # | 1 | 4 | 3 | | # | 3 | 10 | 7 | #+TBLFM: $3 = $c1 + $c2 Bruno