From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id wDAiBgmVmGMLOwAAbAwnHQ (envelope-from ) for ; Tue, 13 Dec 2022 16:06:49 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id MHBFBgmVmGMAFQEA9RJhRA (envelope-from ) for ; Tue, 13 Dec 2022 16:06:49 +0100 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 D3D1B20BEF for ; Tue, 13 Dec 2022 16:06:48 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1p56rC-0005fs-3G; Tue, 13 Dec 2022 10:06:10 -0500 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 1p56r9-0005fK-LU for emacs-orgmode@gnu.org; Tue, 13 Dec 2022 10:06:07 -0500 Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1p56r4-0008Rg-Eu for emacs-orgmode@gnu.org; Tue, 13 Dec 2022 10:06:04 -0500 Received: by mail-lj1-x230.google.com with SMTP id h10so3551953ljk.11 for ; Tue, 13 Dec 2022 07:06:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-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=GhMjcPyCc/PshIv/KlrVH3FFLkngXGhiQoP+Hm70sLM=; b=XtlUFKNzh3FORMLU+DhuQJqi/hnb41dNHzWvZd7Fmq8T0/cX3mDKdjqiuZeGT1pnjM o3e8rbFDQ8ChtBzsOnTkYwuFVX1hJy6HXby/5A7x/EOcN8FHGFRxRWaKDpoX+ynvY6bu 0rc52zHVfRLiaOHDKD1LiyhA/i3GLkZxcPWGyFNQPvokIAdMrWCbFvvC/GITSImnHaR8 jN+1pR86lPjn5i/c3D4tUvmL8zCLlIXMupk5PGB/TpYNDLaRfFMa7n/sAgzO/MtL65Zv ETjcDKyRVupbYQkgkmuNAJbBUJ+mlShM0RQJpEdjOfKjMGKETdUWeQ0mRYJhOxoR8Gn9 Ae9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-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=GhMjcPyCc/PshIv/KlrVH3FFLkngXGhiQoP+Hm70sLM=; b=kIK9G0E2vnYM9SY2+x2h3ZYH2LBDX+wS1rbAOu4xAvVlVp4IY7UPLVq9EVwQHlU6Js OUJDSc54Q7ZzST3YsK+ZDomkB/ZXA8J8F0r6rbdJ1JGoZef5vpI0QFfIwLPWko4HDuDG HtEKO/ICvZr4CKvW67T0dK/IFK0yEpUlZEEAmBwxKWKxBfS6URKqSwlVMcSV4obJcaS4 vyEdXaBD+1hAFY0sukKaqbeqVRaJ4ZgA4s67ke5TgOS8xHf3LppOot/GT9HUGXe+rmCi j7RQXmKklPh1ffSffKKYOoVyyTuuJumlQv/NjWgKEWpNy0FG6b4BQxm4iqpZB5K9L9k+ 9wCg== X-Gm-Message-State: ANoB5plfqz18X8aiuZUFT+XDjOeDAfTZBWWbewUbaV4Ful7q2pOXg8aL 5x3jYLbTstLPibK2AVOx/vI= X-Google-Smtp-Source: AA0mqf5mLhknTiIih7rZ0qCLOQYYjMXb8/U+9HYrElQF6qX61jxTCJ+w69SbTtLSAibCCLpemu10og== X-Received: by 2002:a2e:300a:0:b0:27a:3d9d:81f5 with SMTP id w10-20020a2e300a000000b0027a3d9d81f5mr3653317ljw.5.1670943959271; Tue, 13 Dec 2022 07:05:59 -0800 (PST) Received: from [192.168.0.101] (nat-0-0.nsk.sibset.net. [5.44.169.188]) by smtp.googlemail.com with ESMTPSA id v18-20020a2ea452000000b002778801240asm294598ljn.10.2022.12.13.07.05.56 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 13 Dec 2022 07:05:57 -0800 (PST) Message-ID: <5fa56962-58c7-0a5c-3fcf-88922ab8bb65@gmail.com> Date: Tue, 13 Dec 2022 22:05:55 +0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Org functions in source blocks Content-Language: en-US To: William Denton Cc: emacs-orgmode@gnu.org References: From: Max Nikulin In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=2a00:1450:4864:20::230; envelope-from=manikulin@gmail.com; helo=mail-lj1-x230.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, NICE_REPLY_A=-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.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-Country: US X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1670944008; 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=GhMjcPyCc/PshIv/KlrVH3FFLkngXGhiQoP+Hm70sLM=; b=SYxwM7Y86CkPSrGbejWyiiprGLBswBwjEst6Lg67deL/Br8QyHF4YFzJvxXk5IP2ECZ6aV jrzJ2He/TDffTkkUFYbhGIF8L0txxGJyFI48JyQy42bUsaD+epwz4Mia18cmjv/py0c2e0 K7ikfmkYAcaTJuGUS35p6yjl7QBE6sokNpW8kiSeBWEOsf+CZNXnHOuqs3hgK75hj9+DxV P13TFFzpIewLGazpjUjbTNrLmWBBivd7yuj6XhbyTiaQp6DX0miKw9UjMIwqdSif4Zv18W yrvBvA+ZJi7SxDGeTOpS7NiBVemKcjfnSVaskFZK4X8RU0qmLebOrwtK3eVOZw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=XtlUFKNz; 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-Seal: i=1; s=key1; d=yhetil.org; t=1670944008; a=rsa-sha256; cv=none; b=YkgqrUn0iKASVvwXpM7Sw7wl9WMC1snYwOQl6kO5RH4l6GDXS4oMCkK5FTqdYxoIXNyYHi A6PAhMGYkXel99t+laU7R+yLNlAcX6OfDHq/o0WVEzx9EC1jHH01WGyKJnGqAVMVq+Il5a ebR5e7utq2cXcFMhaSMwY3OKC5WxZeEtvA70BfZ/z0hxp1mORWcpqweaBFPECWLnNU+IJz RSI2p7z7PQyVpg5XNfFnIzl9zJWdpZRoV+cP+uxyXyF03V6HSlYf0IlVczD8W67ZD6BRjK M55+fl8GeiXqSIDXsRXUI1AewfcjGTOXc1g56yvcXhw8ZcR0T2rFTm3huG3mXg== X-Migadu-Spam-Score: -0.17 X-Spam-Score: -0.17 X-Migadu-Queue-Id: D3D1B20BEF X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=XtlUFKNz; 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) X-TUID: fR14xKHRJtse On 12/12/2022 10:23, William Denton wrote: > On 10 December 2022, Max Nikulin wrote: > >> @I$A and the "remote" function are available in table formulas only. ... > I'll be back with more questions eventually, Using source blocks you may define new functions that you may call from table formulas. You may create an intermediate table to evaluate expressions heavily relied on cell ranges and feed this table to another source block as a variable. By the way, a range may be specified when passing a table as a source block variable, but it uses another syntax, see (info "(org)Environment of a Code Block") https://orgmode.org/manual/Environment-of-a-Code-Block.html So it is possible to mix table formulas and source code blocks.