Re: org-table export to ods/xlsx etc

Re: org-table export to ods/xlsx etc

[edgar]

> Message: 19
> Date: Fri, 16 Jun 2017 10:25:55 +0000
> From: Uwe Brauer <oub@mat.ucm.es>
> To: emacs-orgmode@gnu.org
> Subject: [O] org-table export to ods/xlsx etc
> Message-ID: <87fuf0i5zg.fsf@mat.ucm.es>
> Content-Type: text/plain
> 
> I am sometimes in need to send my org-table spreadhseets to colleagues
> who are using (sigh) excel. I thought sending csv would be enough but 
> it
> turns out,
I want to join you in that *deep* sigh! and thank you for your 
contribution. I may eventually have to use it.

> (defun org-table-export-to-xlsx ()
>   (interactive)
>   (let* ((source-file  (file-name-sans-extension (buffer-file-name
> (current-buffer))))
>          (csv-file (concat source-file ".csv")))
>     (org-table-export csv-file "orgtbl-to-csv")
>     (org-odt-convert csv-file "xlsx")))

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[edgar]

Hello Lars,

I am a beginner with Emacs, so my advice may not be very good. I assume 
that you are using org-ref (I missed part of the conversation). I have 
no problems with PDF and References (well, except that I don't know how 
to set an independent headline. I know this is not clear, but I won't 
hijack your post).

> If I want HTML export with citations, I need to use
> `bibliography:ref.bib' at the end, where I want the list of
> references. However, when exporting to pdf, it works only if I have
> \printbibliography at the end. If I use bibliograph:ref.bib, I get the

In my Org file, I have this at the end:

    bibliographystyle:unsrt
    bibliography:../References.bib

  I have no #+LATEX_HEADER, but I tried this with a clean Emacs (emacs 
-Q; you may need to evaluate line by line), and it works for me:

my_file.org
=================================
#+BEGIN_SRC emacs-lisp
   (require 'package)
   (package-initialize)
   (require 'org)
   (require 'org-ref)
   (require 'ox-latex)

   (setq org-latex-pdf-process
	    '("pdflatex -interaction nonstopmode -output-directory %o %f"
	      "bibtex %b"
	      "pdflatex -interaction nonstopmode -output-directory %o %f"
	      "pdflatex -interaction nonstopmode -output-directory %o %f"))
#+END_SRC

* My first section
   According to cite:SmartGuy17, this should work!

* I want this to say "References"
   I don't need this to say References again:
   bibliographystyle:unsrt
   bibliography:References.bib
=================================

References.bib
=================================
@article{SmartGuy17,
   author =       {A. Smart and Handsome Guy},
   title =        {Enjoying Emacs and Org-mode},
   journal =      {Hacking Accounts of Freedom},
   volume =       {2},
   number =       {4},
   pages =        {1858-1894},
   year =         {2017},
}
=================================

I hope that this helps :) . Good hacking!

Org mode version 9.0.7
GNU Emacs 24.4.1
org-ref: Version 0.9.0

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[John Kitchin]

Try this to get the heading you want. It seems to work for me.

# https://tex.stackexchange.com/questions/17445/how-can-i-change-the-references-to-reference-in-the-thebibliography-environm
# This makes the bibliography section title empty and un-numbered
#+latex: \renewcommand{\bibsection}{\subsection*{}}

* References
bibliographystyle:unsrt
bibliography:References.bib

>
> * I want this to say "References"
>    I don't need this to say References again:
>    bibliographystyle:unsrt
>    bibliography:References.bib
> =================================
>
> References.bib
> =================================
> @article{SmartGuy17,
>    author =       {A. Smart and Handsome Guy},
>    title =        {Enjoying Emacs and Org-mode},
>    journal =      {Hacking Accounts of Freedom},
>    volume =       {2},
>    number =       {4},
>    pages =        {1858-1894},
>    year =         {2017},
> }
> =================================
>
> I hope that this helps :) . Good hacking!
>
> Org mode version 9.0.7
> GNU Emacs 24.4.1
> org-ref: Version 0.9.0
>
> -------------------------------------------------
>
> ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
> $24.95 ONETIME Lifetime accounts with Privacy Features!
> 15GB disk! No bandwidth quotas!
> Commercial and Bulk Mail Options!


--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[edgar]

On 2017-06-18 20:38, John Kitchin wrote:
> https://tex.stackexchange.com/questions/17445/how-can-i-change-the-references-to-reference-in-the-thebibliography-environm
> # This makes the bibliography section title empty and un-numbered
> #+latex: \renewcommand{\bibsection}{\subsection*{}}
> 
> * References
> bibliographystyle:unsrt
> bibliography:References.bib
> 
Thanks, I solved it by switching to BibLaTeX, as described in M-x 
org-ref-help :)



-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

> Check out org-format-latex-options.  I have, for the same or similar 
> scenario:
> 
> #+begin_src emacs-lisp
>   (setq org-format-latex-options
>         '(:foreground "white" :background "black" :scale 3
>                       :html-foreground "Black" :html-background 
> "Transparent"
>                       :html-scale 1.0
>                       :matchers ("begin" "$1" "$" "$$" "\\(" "\\[")))
> #+end_src

Thanks, Eric. Unfortunately, that did not work. It does change the 
background and foreground colors, but the \tensor symbol is now 
"invisible" (it is black, and the background is also black). The rest of 
the equation looks fine.

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[Eric S Fraga]

[-- Attachment #1: Type: text/plain, Size: 436 bytes --]

On Saturday, 17 Jun 2017 at 02:34, edgar@openmail.cc wrote:

[...]

> Thanks, Eric. Unfortunately, that did not work. It does change the 
> background and foreground colors, but the \tensor symbol is now 
> "invisible" (it is black, and the background is also black). The rest of 
> the equation looks fine.

Strange.  Maybe post an ECM for others to experiment with?
-- 
: Eric S Fraga via Emacs 26.0.50, Org release_9.0.6-425-gf4fca1

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 194 bytes --]

Re: How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

> Message: 27
> Date: Sat, 17 Jun 2017 16:56:37 +0100
> From: Eric S Fraga <e.fraga@ucl.ac.uk>
> To: emacs-orgmode@gnu.org
> Subject: Re: [O] How to export LaTeX amsmath align bmatrix to ODT?
> Message-ID: <871sqiehfu.fsf@t3610>
> Content-Type: text/plain; charset="us-ascii"
> 
> Strange.  Maybe post an ECM for others to experiment with?
Hello Eric,

What is an ECM and how do I produce it? (this is a honest question).


Edgar

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[Eric S Fraga]

[-- Attachment #1: Type: text/plain, Size: 349 bytes --]

On Saturday, 17 Jun 2017 at 23:13, edgar@openmail.cc wrote:
> What is an ECM and how do I produce it? (this is a honest question).

Sorry: French for minimal but complete example so that others can try to
reproduce the problem.  See the FAQ:
http://orgmode.org/worg/org-faq.html


-- 
: Eric S Fraga via Emacs 26.0.50, Org release_9.0.8-563-g27c2ae

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 194 bytes --]

How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

Hello,

I have been making progress with my export procedure to ODT. I would 
like to know if someone knows how to export the following LaTeX block to 
ODT correctly:

\[\begin{align} \begin{bmatrix} a = 1 & b=2 \\ c=3 & d = 4 \end{bmatrix} 
\end{align}\]

\[\begin{align}  a = & 1 + 2 + 3 + 4 \\ c = &  4 \end{bmatrix} 
\end{align}\]

As always, any help is welcome :) .


Edgar

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

On 2017-06-10 04:54, edgar@openmail.cc wrote:
> Hello,
> 
> I have been making progress with my export procedure to ODT. I would
> like to know if someone knows how to export the following LaTeX block
> to ODT correctly:
> 
> \[\begin{align} \begin{bmatrix} a = 1 & b=2 \\ c=3 & d = 4
> \end{bmatrix} \end{align}\]
> https://www.vfemail.net/roundcube/?_task=mail&_action=compose&_id=289067995593b7fd683a1f#
> \[\begin{align}  a = & 1 + 2 + 3 + 4 \\ c = &  4 \end{bmatrix} 
> \end{align}\]
> 
> As always, any help is welcome :) .
> 
> 
> Edgar

By the way, I tried with latexmlmath and mathtoweb.jar without success.

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

On 2017-06-10 05:13, edgar@openmail.cc wrote:
> On 2017-06-10 04:54, edgar@openmail.cc wrote:
>> Hello,
>> 
>> I have been making progress with my export procedure to ODT. I would
>> like to know if someone knows how to export the following LaTeX block
>> to ODT correctly:
>> 
>> \[\begin{align} \begin{bmatrix} a = 1 & b=2 \\ c=3 & d = 4
>> \end{bmatrix} \end{align}\]
>> https://www.vfemail.net/roundcube/?_task=mail&_action=compose&_id=289067995593b7fd683a1f#
>> \[\begin{align}  a = & 1 + 2 + 3 + 4 \\ c = &  4 \end{bmatrix} 
>> \end{align}\]
>> 
>> As always, any help is welcome :) .
>> 
>> 
>> Edgar
> 
> By the way, I tried with latexmlmath and mathtoweb.jar without success.

Ok. I got it (with a minor glitch). If someone can help me to get the 
right colors on the screen (my screen is black; the \tensor symbol is 
also black), I would appreciate it. Now I can export to ODT with my 
custom symbols and the bmatrix environment.

For the record, I had modified org-preview-latex-process-alist to get 
custom symbols, and this got in the way of the LaTeX bmatrix environment 
(I don't know how; I was loading a file with with :latex-header as 
"\\input{preamble.tex}").

My partial answer (it is partial, because the \tensor preview renders in 
a different color than the rest of symbols): Instead of modifying 
org-preview-latex-process-alist, the answer I modified 
org-format-tex-header. I added the following at the end of M-x 
customize-variable org-format-tex-header (I leave it here for posterity; 
I added some symbols: tensor, derivative, vector, Roman numeral, etc.)

\usepackage{stackengine}
\stackMath
% Does not work
% \newcommand\tenq[2]{%
% \def\useanchorwidth{T}%
%  \ifnum#1>1%
%    
\stackunder[0pt]{\tenq[\numexpr#1-1\relax]{#2}}{\scriptscriptstyle\sim}%
%  \else%
%    \stackunder[1pt]{#2}{\scriptscriptstyle\sim}%
%  \fi%
%}

% Change del operator to d
% 
http://tex.stackexchange.com/questions/178946/better-automatic-spacing-of-differential-d
\renewcommand{\d}[1]{\mathop{\mathrm{d}{#1}}\!{}}
\newcommand{\del}[1]{\d{\left(#1\right)}}
\newcommand{\diff}[2]{
   \frac{\d{}}{\d{#2}}
   \left(#1\right)}
\newcommand{\deriv}[2]{
   \frac{\del{#1}}{\d{#2}}}

% https://tex.stackexchange.com/a/229547
\renewcommand{\vec}[1]{
   \hbox{\oalign{$#1$\crcr\hidewidth$\scriptscriptstyle\sim$\hidewidth}}}
% --- Define \dvec and \ddvec for dotted and double-dotted vectors.
\newcommand{\dvec}[1]{\dot{\vec{#1}}}
\newcommand{\ddvec}[1]{\ddot{\vec{#1}}}

% 
https://tex.stackexchange.com/questions/229543/double-tilde-symbol-under-letter
\newcommand{\dtens}[1]{
   
\stackunder[0pt]{\stackunder[1pt]{#1}{\scriptscriptstyle\sim}}{\scriptscriptstyle\sim}}

\newcommand{\ftens}[1]{
   
\stackunder[0pt]{\stackunder[0pt]{\stackunder[0pt]{\stackunder[1pt]{#1}{\scriptscriptstyle\sim}}{\scriptscriptstyle\sim}}{\scriptscriptstyle\sim}}{\scriptscriptstyle\sim}
}

% Define \tensor and \mtensor (matrix)
\newcommand{\tensor}[1]{\dtens{#1}}
\newcommand{\tens}[1]{\ftens{#1}}

\newcommand{\mtensor}[1]{%
   \left[{\tensor{#1}}\right]}
% --- Define \dtens and \ddtens for dotted and double-dotted tensors.
\newcommand{\dtens}[1]{\dot{\tensor{#1}}}
\newcommand{\ddtens}[1]{\ddot{\tensor{#1}}}
% --- Define \dmtens and \ddmtens for dotted and double-dotted tensors.
\newcommand{\dmtens}[1]{\dot{\mtensor{#1}}}
\newcommand{\ddmtens}[1]{\ddot{\mtensor{#1}}}

% Trace
\newcommand{\Tr}[1]{\mathop{\mathrm{tr}}\!{}\left(#1\right)}

% Have a thicker line for the mean value
%\newcommand*{\mean}[1]{\overbracket[0.65pt][-1pt]{#1}}
% amssymb, amsmath
% adapt: 
http://tex.stackexchange.com/questions/22100/the-bar-and-overline-commands
\newcommand{\mean}[1]{\mkern 
3mu\overbracket[0.65pt][-1pt]{\mkern-3mu#1\mkern-3mu}\mkern 3mu}

% Roman number III
\def\III{I\hspace{-2pt}I\hspace{-2pt}I}

-------------------------------------------------

ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[Nicolas Goaziou]

Hello,

edgar@openmail.cc writes:

> On 2017-06-10 05:13, edgar@openmail.cc wrote:
>> On 2017-06-10 04:54, edgar@openmail.cc wrote:
>>> Hello,
>>>
>>> I have been making progress with my export procedure to ODT. I would
>>> like to know if someone knows how to export the following LaTeX block
>>> to ODT correctly:
>>>
>>> \[\begin{align} \begin{bmatrix} a = 1 & b=2 \\ c=3 & d = 4
>>> \end{bmatrix} \end{align}\]
>>> https://www.vfemail.net/roundcube/?_task=mail&_action=compose&_id=289067995593b7fd683a1f#
>>> \[\begin{align}  a = & 1 + 2 + 3 + 4 \\ c = &  4 \end{bmatrix}
>>> \end{align}\]

I'm a bit lost here. In particular, I'm able to export the example above
out-of-the-box, provided I add "#+options: tex:dvipng" or some such in
the document.

> For the record, I had modified org-preview-latex-process-alist to get
> custom symbols, and this got in the way of the LaTeX bmatrix
> environment (I don't know how; I was loading a file with
> with :latex-header as "\\input{preamble.tex}").
>
> My partial answer (it is partial, because the \tensor preview renders
> in a different color than the rest of symbols): Instead of modifying
> org-preview-latex-process-alist, the answer I modified
> org-format-tex-header. I added the following at the end of M-x 
> customize-variable org-format-tex-header (I leave it here for
> posterity; I added some symbols: tensor, derivative, vector, Roman
> numeral, etc.)

I don't think you need to modify `org-format-latex-header' at all. There
is `org-latex-packages-alist' for that.

So, is there a bug in the ODT export back-end? If so, could you post an
ECM? Loads of LaTeX code doesn't help understanding the issue.

Regards,

-- 
Nicolas Goaziou

Re: How to export LaTeX amsmath align bmatrix to ODT?

[Eric S Fraga]

[-- Attachment #1: Type: text/plain, Size: 800 bytes --]

On Monday, 12 Jun 2017 at 21:36, edgar@openmail.cc wrote:

[...]

> Ok. I got it (with a minor glitch). If someone can help me to get the 
> right colors on the screen (my screen is black; the \tensor symbol is 
> also black), I would appreciate it. Now I can export to ODT with my 
> custom symbols and the bmatrix environment.

Check out org-format-latex-options.  I have, for the same or similar scenario:

#+begin_src emacs-lisp
  (setq org-format-latex-options
        '(:foreground "white" :background "black" :scale 3
                      :html-foreground "Black" :html-background "Transparent"
                      :html-scale 1.0
                      :matchers ("begin" "$1" "$" "$$" "\\(" "\\[")))
#+end_src

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 26.0.50, Org release_9.0.7-531-g530113

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 194 bytes --]