From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.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 gKHGOjo7u2QbpQAASxT56A (envelope-from ) for ; Sat, 22 Jul 2023 04:13:15 +0200 Received: from aspmx1.migadu.com ([2001:41d0:306:2d92::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id uDWROjo7u2QERgAAauVa8A (envelope-from ) for ; Sat, 22 Jul 2023 04:13:14 +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 9ACD3448C5 for ; Sat, 22 Jul 2023 04:13:14 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20221208 header.b=B325WYUd; 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=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1689991994; 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: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=vWGXWP74ZdgQSrgptTyJpX5hgXFp3oKDRiRZQ/HIqaM=; b=EpLxE+GElGOjqAOXkxCBGsIfB7HYUJYU84qW0XxffztVg2gGMewFquTc98F7w8ebW/9TVU ktMYTpGwmIMMX/N3qgs+5SNrTHIl/pwYSOeOwfnaVbX2CrqrpfbTH1QOu+Q0aXyUuY6BGr /4xM/TZDI7CBX9rXfMvKJecdqUoQ75w/hNtPnPJAVCc0/3PnA4rsvFsG1nWNDatLtEYe+B T1ABHenWJcevOsNmT2r/lE9JW1+i63Kd9NImv+rBr8lf9IZOZ0Gz9TSx1lscHMLouGKSbX 8EbjYJWFzhDXRPZ5T81CD6uRy49YbFEdpswGTyml4HBmtBo/qJ2DBlFfrEH1Pw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1689991994; a=rsa-sha256; cv=none; b=LnarYpYmm2xi/NODAvZpBK++nB6M2btsXAiYHcXdtaxi4dNmDvdBMUtMl8wPjpMxHC0eLP 3hnI5ZLZhHlb5ldO2hxMLJCUR4pzs7hIpTPtzcBOx6+aBiyedo+dyXnBENguc9bzxXFNzY mQpCAfX0Nmlz+ufN6V+85xEmTBO8hISs6xlQzghnts4W+Ne8lcIv4cB2epLzz5/kc4kHu/ yVraSj6gwsD0Fc23FIIUnMp6z7i4G4ud9Wi2z1riiu1Y1BsP1vwll6a98oV205nG7prteI DxWqTPSENTUMnigIvCtihVpbtXHbEHgzCnvQ82YnBGA+/ckKx021t5tDkjW9WA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20221208 header.b=B325WYUd; 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=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qN26U-0007G0-3r; Fri, 21 Jul 2023 22:12:18 -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 1qN26S-0007Fc-B1 for emacs-orgmode@gnu.org; Fri, 21 Jul 2023 22:12:16 -0400 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qN26Q-0000IP-7j for emacs-orgmode@gnu.org; Fri, 21 Jul 2023 22:12:16 -0400 Received: by mail-lf1-x130.google.com with SMTP id 2adb3069b0e04-4fb96e2b573so4044438e87.3 for ; Fri, 21 Jul 2023 19:12:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689991932; x=1690596732; h=content-transfer-encoding:in-reply-to:mail-followup-to:from :references:cc:to:content-language:subject:user-agent:mime-version :date:message-id:sender:from:to:cc:subject:date:message-id:reply-to; bh=vWGXWP74ZdgQSrgptTyJpX5hgXFp3oKDRiRZQ/HIqaM=; b=B325WYUdH2Qw7357iSdUVmJXPMxPa6m33Md1FZ4wBOojmMpQloRY37I3K1abx3topv 67QOvOpAcG56HMfO4jOXk81nJ+h0jgX45eV5RrbCXFLd7LvSmLoYsEMzyJxy+K5f2ktT dpExz+doODwoEYpFc5sNi1/xSWxEjcHwoP8wi4gFHa6h1JyZjhvZumile91zPQ7oHzcM YNy8yxVexDI4NJ2DFLUZn1VlFvvNIelXO6A8Otfch287c4S/of/0LsezxtNWm2LOsR17 YdxYSPvIHcmesc+O5iasQG8r+gYe0Krv+pa1rzo0YppxdZGoVPs77aWNpbMEeJpbxUZz c8jA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689991932; x=1690596732; h=content-transfer-encoding:in-reply-to:mail-followup-to:from :references:cc:to:content-language:subject:user-agent:mime-version :date:message-id:sender:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=vWGXWP74ZdgQSrgptTyJpX5hgXFp3oKDRiRZQ/HIqaM=; b=l4j1N3FmGHFpu5gCkUL4VEFiRZ7NRzXRiQsA89R3T+b2/TlPLlYWl+EhissHi//RFT FkI6S6iXngHNZpNsUG7erHnfdJCoEDzVc80JJXJi5fnUcspBbTAjJFQjE/6HEM2YhSPB MNEjChQ+tSHEJJbaRsF+pNPwS7d8gS0expSgXXgdvOF2hNN7rseYZ+VNf3xnq+6UL2P9 SRfI0oFcM7U5ripS9zdueVxqT4qIBjmmNewzoJAmU+U03hcF8o0AuUowdYPE5wHrwtdi AadOgC0LDaB8zaPWuPowqN/maAGJco9qFEoVHbGRp+YVSmGga7V4Rnfrm0f8V1CeeWhf MVBw== X-Gm-Message-State: ABy/qLYb4bmpX3tPug905Zqz8AoyD+SHqFwsuwlJi7SJJYdsXP/0908T 88bLTDuDWRJLNep3KPbvevo= X-Google-Smtp-Source: APBJJlHGCsKQevoy8rgY6Xfl6lf5qKOwkmuPFkov/FjmtuVSs3xQqptN6RQ9+v6rpS/UOa+omwxCcg== X-Received: by 2002:a05:6512:3ad:b0:4fc:3755:37d9 with SMTP id v13-20020a05651203ad00b004fc375537d9mr2335633lfp.68.1689991932026; Fri, 21 Jul 2023 19:12:12 -0700 (PDT) Received: from [192.168.0.101] (nat-0-0.nsk.sibset.net. [5.44.169.188]) by smtp.googlemail.com with ESMTPSA id o17-20020ac24951000000b004f86673a47dsm972660lfi.75.2023.07.21.19.12.11 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 21 Jul 2023 19:12:11 -0700 (PDT) Message-ID: <2bf38bed-4cdd-e195-ef24-7389bbf8e235@gmail.com> Date: Sat, 22 Jul 2023 09:12:10 +0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: [PATCH] lisp/org-table.el: Allow named columns on lhs Content-Language: en-US, ru-RU To: Gavin Downard Cc: emacs-orgmode@gnu.org References: <877cqwbpa2.fsf@runbox.com> <874jm01h1x.fsf@localhost> <3f2ddcff-1be1-e0dd-8cd3-f15f35d6393f@gmail.com> <87tttx9j3d.fsf@runbox.com> From: Max Nikulin Mail-Followup-To: Gavin Downard , emacs-orgmode@gnu.org In-Reply-To: <87tttx9j3d.fsf@runbox.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=2a00:1450:4864:20::130; envelope-from=manikulin@gmail.com; helo=mail-lf1-x130.google.com X-Spam_score_int: 11 X-Spam_score: 1.1 X-Spam_bar: + X-Spam_report: (1.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, NICE_REPLY_A=-0.094, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_SBL_CSS=3.335, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=no 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-Scanner: mx2.migadu.com X-Migadu-Spam-Score: 2.86 X-Spam-Score: 2.86 X-Migadu-Queue-Id: 9ACD3448C5 X-TUID: Miub3M39mpdJ On 22/07/2023 01:33, Gavin Downard wrote: > > Max Nikulin writes: >> When I tried table formulas a couple of years ago I was surprised that it is not >> possible to use column names to specify target cells. At first glance it should >> be a great feature. Have you searched the mailing list archive whether it was >> requested earlier? There are might be reasons why it has not been implemented. >> Org spreadsheets are quite complicated. > > Surprisingly, I wasn't able to find much. Generally all I could find > talked about hline references , which are similarly unsupported. Quick search revealed some messages where the feature was mentioned. However there are no objections from the developers and maintainers: https://list.orgmode.org/CAA3095_PFhoSFDZFQSFYB3DEe-PbmRbnHkWzpEfx4ChxLHuz-g@mail.gmail.com/T/#u Bug: assignment to named column - not working as expected 2020-02-29 https://list.orgmode.org/CAJcAo8sF=2UG0ONvq4SSpRLyKfo-0VJfhsFMUerOJokovCLC2g@mail.gmail.com/T/#u is this spreadsheet correct? 2012-12-01 https://list.orgmode.org/CALPHr6yH_etZa0=GajRMbu7x-oEJGdAP=3XEveLJnpEf0tQeLw@mail.gmail.com/ Bug: column names in tables cannot be used as target in table formula 2011-08-19 Perhaps git blame for the manual may give some hints. If the change is really old then org.texi (removed at certain moment) should be inspected as well. By the way, the manual needs an update if the suggested patch is applied.