From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id EDW8AxaiIGCJRwAA0tVLHw (envelope-from ) for ; Mon, 08 Feb 2021 02:29:42 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id pr4HOxWiIGCbNwAAbx9fmQ (envelope-from ) for ; Mon, 08 Feb 2021 02:29:41 +0000 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 57A7F9403D2 for ; Mon, 8 Feb 2021 02:29:41 +0000 (UTC) Received: from localhost ([::1]:50570 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l8wJ0-0007D3-TE for larch@yhetil.org; Sun, 07 Feb 2021 21:29:38 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:56478) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l8wGh-0006Ez-IE for emacs-orgmode@gnu.org; Sun, 07 Feb 2021 21:27:15 -0500 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]:34738) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1l8wGd-00026S-OX for emacs-orgmode@gnu.org; Sun, 07 Feb 2021 21:27:15 -0500 Received: by mail-qt1-x832.google.com with SMTP id c1so9435982qtc.1 for ; Sun, 07 Feb 2021 18:27:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=QLBUSevMtEcOKsM1jtut3W3p5i5/+U/u7jtGzFCrnqc=; b=j1+Xb+ZvPmEglGrUrHXbDuL1YULykWn+UoosYx5/+ibU21DNH9CWUou8mkpwk9fgoz Sgm72dtFoPY+7RXDOWtp65iinEYHhQ+Ujrav6W8nJ5RqHDONgO0ZvejqnENU7K8z8rZI 6pHw2Th6B9nParRTDxy7kQZWZws+lOd7LHf0DA94M3VdtkTUHINWJ7JMUBpjffiw768Z tKTEcKk7KEq0/DwMKejP+WfvSTPjPedkSWZEvImjjBDyISDd3eVgYahklbZdIukHmyl9 Fsjzeo63qTEAp9/wjY/ByGTPJOXnS+StDdZVOOhgRv22B9fX7CmctFM5wyzEJsOiGRF5 84VA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=QLBUSevMtEcOKsM1jtut3W3p5i5/+U/u7jtGzFCrnqc=; b=jOjdGTVAihrdkxFQaNpIq7wCzEDk9L+JoyBkOeEshO2vTv4izuHFi9SyZZyvhdwJtK LkkbCVDXAKD+kft936ZUTuS281p4dPsAinHaJDdXiZyTpMquwyoIe/ciiOs0Y2MOpgoX RBlEhHlgTwMjc23ih5wpllKH/PKMj7SDzNooGRB0vxKMw5wSYj/9RKxaBe/MuX+h38QP kPxqoN5cPylDolZt0fm+iv2vqer4fb6M5xFaVd4/OWSCp60JJJIHNk0c79CcrmCKMu51 3iuWmXBpE1P9wQ15tVpFnoSvV3B+UcFHAnrnwtDaumNiaNM5EOGyCyjUVHX5LgU3Kv9M QJmw== X-Gm-Message-State: AOAM532dSgh30ASjHwhaRTk2kyk9PDZOpflQXVxc29sd5ThB7jYzQmfb O/Y98qoba8mOeQ6bPSLoqvP57QeMv/T2zOBBW2YQnBrfiTg= X-Google-Smtp-Source: ABdhPJxzZUmYkbdzXvd5ulOIA3EsuqNU+d6WVQROpjzdGdp/euGXK9kYjpjzLt/gw7Q+PraWexe2DmPOY0oTRx0nmbo= X-Received: by 2002:ac8:7cb:: with SMTP id m11mr13900076qth.307.1612751229917; Sun, 07 Feb 2021 18:27:09 -0800 (PST) MIME-Version: 1.0 From: Ethan Glasser-Camp Date: Sun, 7 Feb 2021 21:26:58 -0500 Message-ID: Subject: Recalculate mixed tables/source blocks To: emacs-orgmode Content-Type: multipart/alternative; boundary="0000000000002b9d2f05bac9e81c" Received-SPF: pass client-ip=2607:f8b0:4864:20::832; envelope-from=ethan.glasser.camp@gmail.com; helo=mail-qt1-x832.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, HTML_MESSAGE=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.23 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" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -3.06 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=j1+Xb+Zv; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 57A7F9403D2 X-Spam-Score: -3.06 X-Migadu-Scanner: scn0.migadu.com X-TUID: 8DvkZZ+8b8yp --0000000000002b9d2f05bac9e81c Content-Type: text/plain; charset="UTF-8" Hi! I've been learning about the spreadsheet features of org-table and how to use them with org-babel. They're both really cool and I was happy to be able to convert a Gnumeric spreadsheet into something that I can keep in version control. Now I have a document that consists of mutually-referential tables and source blocks. So, for example, I have table A, then table B which refers to table A, then source block C which accesses table B using a noweb reference, and finally table D which uses the output of source block C in its formulas. I want to be able to change the "inputs" in table A and see the updates in table D. So far the easiest way I have found to do this is to use `org-table-recalculate-buffer-tables`, then `org-babel-execute-buffer`, then `org-table-recalculate-buffer-tables` again. I already made at least one mistake by rerunning the source block without remembering to refresh intermediate tables. I was wondering if there is another way, either simpler or more robust? Thanks! Ethan [Please cc me on replies, I'm not subscribed to the list.] --0000000000002b9d2f05bac9e81c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi! I've been learning about the spreadsheet feat= ures of org-table and how to use them with org-babel. They're both real= ly cool and I was happy to be able to convert a Gnumeric spreadsheet into s= omething that I can keep in version control.

Now I= have a document that consists of mutually-referential tables and source bl= ocks. So, for example, I have table A, then table B which refers to table A= , then source block C which accesses table B using a noweb reference, and f= inally table D which uses the output of source block C in its formulas.

I want to be able to change the "inputs" in= table A and see the updates in table D. So far the easiest way I have foun= d to do this is to use `org-table-recalculate-buffer-tables`, then `org-bab= el-execute-buffer`, then `org-table-recalculate-buffer-tables` again. I alr= eady made at least one mistake by rerunning the source block without rememb= ering to refresh intermediate tables. I was wondering if there is another w= ay, either simpler or more robust?

Thanks!
=

Ethan

[Please cc me on r= eplies, I'm not subscribed to the list.]
--0000000000002b9d2f05bac9e81c--