radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code

radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code

[AW]

Dear all,

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

Re: radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code

[AW]

On wednesday, 18. April 2012, 13:00:25 wrote AW:
> Dear all,

Sorry for this attempt to insist on something else than buriel in the digital 
mass grave of 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.

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

Re: radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code

[William Henney]

[-- 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 --]

Re: radiotables in LaTeX-document: export numbers from orgtbl with commas as decimal separators instead of periods; with MWE and lisp-code => SOLVED

[AW]

There is an easy solution on the LaTeX side: we simply have to use the package 
»numprint« and to wrap every number of the second column with 
»\numprint{number}«, then it will be printed in a suitable way.

We get this by adding to the #+ORGTBL - line this code: 

:fmt (2 "\\numprint{%s} EUR")

So the whole line looks like this:

#+ORGTBL: SEND anteile orgtbl-to-latex :splice t :skip 1 :fmt (2 
"\\numprint{%s} EUR")

Sorry for the noise.

Regards,

Alexander

> Dear all,
> 
> 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