From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1.migadu.com ([2001:41d0:403:4876::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id sNK2B5gc/GZnAgEA62LTzQ:P1 (envelope-from ) for ; Tue, 01 Oct 2024 16:00:24 +0000 Received: from aspmx1.migadu.com ([2001:41d0:403:4876::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1.migadu.com with LMTPS id sNK2B5gc/GZnAgEA62LTzQ (envelope-from ) for ; Tue, 01 Oct 2024 18:00:24 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=city17.xyz header.s=dkim header.b=SCye95dy; dmarc=pass (policy=reject) header.from=city17.xyz; 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" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1727798423; 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:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=Qh/bNTDWPN+uJML/TNfgAbDrMU1zQuWBrIZmMsMXqN0=; b=myuaJ0qwiU7wuoT8zNu/AKxg46UGcO/Oysoq2x2oXMPbSCr+MVvxOqrPQ3tdq0ll0a2IIU O94PaWH5el3apNc1LKrFOTpds/w9Xlmf6UFiNy7GAhXkXmU4nFmX2Pn3XXu3I7DNh4mXxb jsY862Z/RxsfsvBYuxxXCQholDFAGatbiZloLCKjFXGkVX36dG9CfjzU7BO6fNu+Msh4n7 4v7iVyW4ak+JmQoTg+VOzTe30CeE6ezRmAoHYBMvWKjA4GLhK/Ev/ZkViUIXZWT6RsPrbP guJusA8DYOpQApN+f4P8Vx4RtWB9TaP0Yo/EPmlYebv8obePZnEiFWgJ0/T55w== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=city17.xyz header.s=dkim header.b=SCye95dy; dmarc=pass (policy=reject) header.from=city17.xyz; 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" ARC-Seal: i=1; s=key1; d=yhetil.org; t=1727798423; a=rsa-sha256; cv=none; b=PzaXfZyxfjs3igmcLez1W2TE6TbxvuUoHb2UysPiHN5ECvMTcAwg86DcffwmzFzBJAO2LQ PG+mSQjrkqyFWioIKYN0GBC2+rAYzCM6IegnxXOH7nWE5iAqQ/9bAE1OKulSlr72uForg1 TjWWEXy3vzH1WPsw40r0oz3NL1DGo3rtySnoWMe4bt46uVFbKFIVXIBwy2MHXIDNqIwVOT J69if/4gw1O5T/wFCoLOlJl9UxVqyX9ZGunRfMMfkyB7WstvURkQc/SWfi5P0AGdnTjDbg dPJUVkfYdneSzEMqzZXFvNinwk5WgSa+9J4c1mORYk1Ax4hecw15V2/uViLeOw== 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 AEB5983CA4 for ; Tue, 01 Oct 2024 18:00:23 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1svdzW-0006VJ-BK; Tue, 01 Oct 2024 10:36:42 -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 1svdyy-00066I-Mq for emacs-orgmode@gnu.org; Tue, 01 Oct 2024 10:36:16 -0400 Received: from mail.city17.xyz ([45.91.101.53]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1svdyq-0001pw-5h for emacs-orgmode@gnu.org; Tue, 01 Oct 2024 10:36:05 -0400 Received: from [127.0.0.1] (localhost [127.0.0.1]) by localhost (Mailerdaemon) with ESMTPSA id 9D8984E26C for ; Tue, 1 Oct 2024 16:35:47 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=city17.xyz; s=dkim; t=1727793348; h=from:subject:date:message-id:to:mime-version:content-type; bh=Qh/bNTDWPN+uJML/TNfgAbDrMU1zQuWBrIZmMsMXqN0=; b=SCye95dyZHhVajB++GZVrJsVdxobGsn+IEWxDLuWgz18K5cTbPhV7EzWfe6tejGJE0GpDR 4eiJ4Dy8j7SbwZFKlOgZwssj78/fZjmvDuvhDZhJTtCJwKpOhxRI9s9ki7OfKNQ3nN29J3 d/NVghCUwInJYOihXEB/7pKhTR2WhOf7zloz/5Ru04btXXzq5iRyqs1zW0PrAyd5lSRiyO F+BRi2evwr5lVq3eoTTth/Y8Ie2Wzv3D2GXniPAxCr9Rb3rVUH5PgCquYuIsVL6CrCf+67 H4AP18G24qGTob+fk7e6stmQPuqWrO/CI3fdmU63ylHP0WOEOZS7Or3n9soEpQ== From: jman To: "emacs-orgmode@gnu.org" Subject: [Question] Getting cell value and use it in table formula Date: Tue, 01 Oct 2024 16:35:47 +0200 Message-ID: <87jzerriv0.fsf@city17.xyz> MIME-Version: 1.0 Content-Type: text/plain; format=flowed X-Last-TLS-Session-Version: TLSv1.3 Received-SPF: pass client-ip=45.91.101.53; envelope-from=emacs-orgmode@city17.xyz; helo=mail.city17.xyz 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, RCVD_IN_VALIDITY_CERTIFIED_BLOCKED=0.001, RCVD_IN_VALIDITY_RPBL_BLOCKED=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-Queue-Id: AEB5983CA4 X-Migadu-Scanner: mx10.migadu.com X-Migadu-Spam-Score: -1.99 X-Spam-Score: -1.99 X-TUID: N32Ya9LQvWL5 Hello there, Let's look at the following table: ----------s---------s---------- | EUR | USD | Exchange rate | |-----+--------+---------------| | 10 | 8.97 | 0.897 | | 15 | 13.455 | | #+TBLFM: $2='(* (string-to-number $1) (string-to-number (org-table-get 2 3))) ----------e---------e---------- I've tried a number of things but this is the only incantation is able to retrieve the value from the cell "@2$3" and use it into the table formula. Is there a cleaner way to retrieve a cell value and use it into a table formula that is a lisp expression? Any suggestion? Thanks. Best,