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 aFzvD45KE194DQAA0tVLHw (envelope-from ) for ; Sat, 18 Jul 2020 19:16:30 +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 SMupC45KE18AegAAbx9fmQ (envelope-from ) for ; Sat, 18 Jul 2020 19:16:30 +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 4E6579403AA for ; Sat, 18 Jul 2020 19:16:29 +0000 (UTC) Received: from localhost ([::1]:41928 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jwsJw-0000nO-8p for larch@yhetil.org; Sat, 18 Jul 2020 15:16:28 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53342) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jwsJU-0000nE-Fl for emacs-orgmode@gnu.org; Sat, 18 Jul 2020 15:16:00 -0400 Received: from static.214.254.202.116.clients.your-server.de ([116.202.254.214]:51120 helo=ciao.gmane.io) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jwsJS-00080J-MV for emacs-orgmode@gnu.org; Sat, 18 Jul 2020 15:16:00 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1jwsJO-0007RD-2D for emacs-orgmode@gnu.org; Sat, 18 Jul 2020 21:15:54 +0200 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-orgmode@gnu.org To: emacs-orgmode@gnu.org From: Uwe Brauer Subject: Could Babel honor spreadsheet formulas? Date: Sat, 18 Jul 2020 21:15:48 +0200 Message-ID: <87wo30skgr.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Cancel-Lock: sha1:JtXvBGfAVdsxUfaHFi9AMofYKKw= Mail-Copies-To: never Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-detected-operating-system: by eggs.gnu.org: First seen = 2020/07/18 15:15:54 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -8 X-Spam_score: -0.9 X-Spam_bar: / X-Spam_report: (-0.9 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=1, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=mat.ucm.es (policy=none); 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-Spam-Score: 0.59 X-TUID: bVMim/iofEL5 Hello The orgtbl-join package honors spreadsheet as the following example shows #+NAME: TA | Name | col1 | col2 | |-------+------+------| | User1 | 2 | 2 | #+NAME: TB | Name | col3 | |-------+------| | User1 | 4 | #+NAME: Result #+BEGIN: join :mas-table "TA" :mas-column "Name" :ref-table "TB" :ref-column "Name" | Name | col1 | col2 | col3 | | |-------+------+------+------+---| | User1 | 2 | 2 | 4 | 8 | #+TBLFM: $5=vsum($2..$4);f1 #+END: So whenever you actualize TA, the table Results will be upgraded. Unfortunately this package only allow you to add columns not rows. In order to add rows the following code can be used #+begin_src elisp :var table1=TA :var table2=TB :colnames t (append table1 table2 ) #+end_src Restulting in #+RESULTS: | User1 | 2 | 2 | | User1 | 4 | | However when I modify this to #+Name: New #+RESULTS: | User1 | 2 | 2 | 4 | | User1 | 4 | | 4 | #+TBLFM: $4=vsum($2..$3);f1 And upgrade one of the table, execute the babel code, the spreadsheet formula is gone. So could babel somehow respect the spreadsheet formula? Regards Uwe Brauer