From mboxrd@z Thu Jan 1 00:00:00 1970 From: Charles Millar Subject: Re: evaluate TBLFM Date: Thu, 30 Jul 2015 15:41:04 -0400 Message-ID: <55BA7DD0.7010509@verizon.net> References: <5579E556.8090104@verizon.net> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54147) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZKths-0000bz-8U for emacs-orgmode@gnu.org; Thu, 30 Jul 2015 15:41:33 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZKthp-0007Er-19 for emacs-orgmode@gnu.org; Thu, 30 Jul 2015 15:41:32 -0400 Received: from vms173025pub.verizon.net ([206.46.173.25]:62463) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZKtho-0007Cu-SF for emacs-orgmode@gnu.org; Thu, 30 Jul 2015 15:41:28 -0400 Received: from [192.168.1.59] ([24.39.254.154]) by vms173025.mailsrvcs.net (Oracle Communications Messaging Server 7.0.5.32.0 64bit (built Jul 16 2014)) with ESMTPA id <0NSB005EEG0HG3H0@vms173025.mailsrvcs.net> for emacs-orgmode@gnu.org; Thu, 30 Jul 2015 14:41:05 -0500 (CDT) In-reply-to: <5579E556.8090104@verizon.net> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org FWIW, the code in Miguel Ruiz's post earlier today "TBLFM added to updated table as result of a emacs-lisp src block" has pretty much answered my questions. Thank you, Miguel. I'm not sure if it the most efficient or even elegant but here is what I came up with, so please comment and correct if there is a better way #+Name: ATableP #+begin_src rec data: Foo.rec :type Bar :fields date,Description,Amount :results silent #+end_src #+TBLNAME: ATable src emacs-lisp :var table=ATableP :exports results (setq table (cons 'hline table)) (setq table (cons '("Date" "Description" "Inventory") table)) (setq table (append table '(("|Total")))) (setq table (append table '(("\n#+TBLFM: @>$>=vsum(@I$>..@>>$>);%.2f::")))) table #+end_src #+ATTR_LATEX: :environment longtable :align p{60pt}p{280pt}N{8}{2} #+TBLNAME: SCHEDA | date | Description | Amount | (resulting table, after C-c C-v s) |--------|----------------|---------------| | 6-7 | blah | 1.00 | | 6-8 | blah blah | 2.00 | | | Total | 3.00 | On 06/11/2015 03:45 PM, Charles Millar wrote: > Hi, > > I am learning how to use org-babel and want to export (LaTeX) a table > with the final column added at final row, which should be inserted. > The entire process would take place upon exporting to LaTeX/pdf > > Desired result (roughly speaking) > > | date | Description | Amount | > |--------|----------------|---------------| > | 6-7 | blah | 1.00 | > | 6-8 | blah blah | 2.00 | > | | | 3.00 | (this row to be > inserted and then column 3 added) (Also nice if a hline were inserted > before the last row) > > The table is generated from a recutils data base and essentially this > is the set up > > > #+Name: ATable > #+begin_src rec data: Foo.rec :type Bar :fields date,Description,Amount > #+end_src > > #+TBLNAME: ATable > #+TBLFM: @>$>=vsum(@I$>..@>>$>);%.2f > > I have read Using Code Blocks in Org Tables in the Worg Babel > Introduction and searched the lists and am not sure of how to > implement this. > > At the moment I am more interested in solving the column sum problem; > i can kludge an added row using a dummy record in the database. > > Charlie Millar > >