From: Charles Millar <millarc@verizon.net>
To: emacs-orgmode@gnu.org
Subject: Re: evaluate TBLFM
Date: Thu, 30 Jul 2015 15:41:04 -0400 [thread overview]
Message-ID: <55BA7DD0.7010509@verizon.net> (raw)
In-Reply-To: <5579E556.8090104@verizon.net>
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
>
>
prev parent reply other threads:[~2015-07-30 19:41 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2015-06-11 19:45 evaluate TBLFM Charles Millar
2015-07-21 13:28 ` Grant Rettke
2015-07-26 14:01 ` Charles Millar
2015-07-30 19:41 ` Charles Millar [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=55BA7DD0.7010509@verizon.net \
--to=millarc@verizon.net \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).