From: William Henney <whenney@gmail.com>
To: AW <alexander.willand@t-online.de>
Cc: emacs-orgmode@gnu.org
Subject: Re: radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code
Date: Sat, 21 Apr 2012 18:09:57 -0500 [thread overview]
Message-ID: <D5DFF9BBCADD4DD299D33B2DFB465146@gmail.com> (raw)
In-Reply-To: <1662380.9gUVOv7VcX@linux-nyil.site>
[-- Attachment #1: Type: text/plain, Size: 3901 bytes --]
Hi Alexander
On Saturday, 21 April 2012 at 04:22, AW wrote:
> On wednesday, 18. April 2012, 13:00:25 wrote AW:
> >
> Sorry for this attempt to insist on something else than buriel in the digital
> mass grave of gnu.org (http://gnu.org) for my question.
>
> Maybe someone could have a look at it, it would be very usefull to me and
> probably to others: A comma is the decimal separator for amounts in money in
> continental europe. Without replacement of periods with commas _while
> exporting to LaTeX_ you can not use radiotables for any kind of accounting.
>
> If my question lacks sense or has other shortcomings, please tell me. Thank
> you very much.
>
I have no idea how to solve this on the orgtable side, but there are several ways to solve it with LaTeX. That is, your .tex file would still have, for example, "100000.00" but this would be automagically translated to "100\,000,00" when you compile it.
One way is to use the numprint package, which defines a new table column type "n" for typesetting numbers nicely. It is fully localizable to your language.
I attach a slightly modified version of your example to illustrate how it works.
I think that pgftables can probably also do this.
Hope this helps
Will
--
Dr William Henney, Centro de Radioastronomía y Astrofísica,
Universidad Nacional Autónoma de México, Campus Morelia
>
> Regards,
>
> Alexander
>
> >
> > I'd like to use radiotables inside a LaTeX-document. Here is a minimal
> > working example:
> >
> > -----------------------------------------------------------
> > \documentclass[pagesize, ngerman, fontsize=12pt]{scrartcl}
> > \usepackage[T1]{fontenc}\usepackage[utf8]{inputenc}
> > \usepackage{babel, comment, array, booktabs}
> >
> >
> > \title{Sicherheitsbestellung}
> > \subtitle{gag}
> > \begin{document}
> > \maketitle
> >
> > \begin{tabular}{p{0.25\linewidth}p{0.5\linewidth}}%\toprule
> > Bezeichnung & Betrag \\
> > % BEGIN RECEIVE ORGTBL Kaufpreis
> > Kaufpreis & 100000.00 \\
> > Darlehen & -5000.00 \\
> > Summe & 95000.00 \\
> > % END RECEIVE ORGTBL Kaufpreis
> > \bottomrule
> > \end{tabular}
> > \begin{comment}
> > #+ORGTBL: SEND Kaufpreis orgtbl-to-latex :splice t :skip 0
> >
> > | Kaufpreis | 100000.00 |
> > | Darlehen | -5000.00 |
> > | Summe | 95000.00 |
> >
> > #+TBLFM: @3$2=@1$2+@2$2;%.2f
> >
> > \end{comment}
> > \end{document}
> > -----------------------------------------------------------
> >
> > I would like to have the LaTeX table with commas as decimal separators
> > instead of periods, e.g.:
> >
> > »Kaufpreis & 100000,00\\« or even better
> > »Kaufpreis & 100\,000,00\\«.
> >
> > To avoid misunderstandigs: The change of all periods to commas should take
> > place when the org-table is »transfered« to the LaTeX table, not earlier!
> >
> > I found a suggestion by Carsten Dominik here:
> > http://permalink.gmane.org/gmane.emacs.orgmode/42000
> >
> > -----------------------------------------------------------
> > (add-hook 'org-export-preprocess-hook
> > 'org-use-comma-in-exported-tables)
> >
> > (defun org-use-comma-in-exported-tables ()
> > (goto-char (point-min))
> > (while (re-search-forward "\\([0-9]\\)\\.\\([0-9]\\)" nil t)
> > (org-if-unprotected
> > (when (save-match-data (org-at-table-p))
> > (replace-match "\\1,\\2" t nil)))))
> > -----------------------------------------------------------
> >
> > I put that into my .emacs, restarted Emacs, but no result.
> > I'm using Emacs 23.3 and Org-mode version 7.8.02. Please bear in mind that
> > I'm may have made strange mistake, because I do neither have experience
> > with radiotables nor understand lisp.
> >
> > Any help would be appreciated, thanks in advance.
> >
> > Kind regards,
> >
> > Alexander
[-- Attachment #2: tabgerman.tex --]
[-- Type: application/octet-stream, Size: 997 bytes --]
\documentclass[pagesize, ngerman, fontsize=12pt]{scrartcl}
\usepackage[T1]{fontenc}\usepackage[utf8]{inputenc}
\usepackage{babel, comment, array, booktabs}
%% WJH 21 Apr 2012: numprint defines the "n" column type
%% WJH: The autolanguage option will take the language from the document
\usepackage[autolanguage]{numprint}
\title{Sicherheitsbestellung}
\subtitle{gag}
\begin{document}
\maketitle
% WJH: n{6}{2} means 6 digits before and 2 digits after the decimal separator
\begin{tabular}{p{0.25\linewidth}n{6}{2}}%\toprule
Bezeichnung & {Betrag} \\ % WJH: normal text in a "n" column must be in braces to avoid being in math mode
% BEGIN RECEIVE ORGTBL Kaufpreis
Kaufpreis & 100000.00 \\
Darlehen & -5000.00 \\
Summe & 95000.00 \\
% END RECEIVE ORGTBL Kaufpreis
\bottomrule
\end{tabular}
\begin{comment}
#+ORGTBL: SEND Kaufpreis orgtbl-to-latex :splice t :skip 0
| Kaufpreis | 100000.00 |
| Darlehen | -5000.00 |
| Summe | 95000.00 |
#+TBLFM: @3$2=@1$2+@2$2;%.2f
\end{comment}
\end{document}
[-- Attachment #3: tabgerman.pdf --]
[-- Type: application/pdf, Size: 68531 bytes --]
next prev parent reply other threads:[~2012-04-21 23:10 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-04-18 11:00 radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code AW
2012-04-21 9:22 ` AW
2012-04-21 23:09 ` William Henney [this message]
2012-04-21 22:38 ` radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code => SOLVED AW
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=D5DFF9BBCADD4DD299D33B2DFB465146@gmail.com \
--to=whenney@gmail.com \
--cc=alexander.willand@t-online.de \
--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).