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: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: Citations with org-ref in apa style)

[edgar]

> Message: 25
> Date: Sat, 17 Jun 2017 02:25:56 +0000
> From: edgar@openmail.cc
> To: emacs-orgmode@gnu.org
> * I want this to say "References"
>    I don't need this to say References again:
>    bibliographystyle:unsrt
>    bibliography:References.bib
Hello Lars,

I also found M-x org-ref-help useful (go to ** biblatex users).


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: Citations with org-ref in apa style

[Eric S Fraga]

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

On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
> Hi, list!
>
> I'm currently writing an exam in org-mode with org-ref, installed from
> elpa. I think the institution expects to get the referances in apa
> style. So I wonder if I can do that, and how I can do it.

Have you tried?  What happens?
-- 
: Eric S Fraga (0xFFFCF67D), Emacs 26.0.50, Org release_9.0.6-425-gf4fca1

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

Re: Citations with org-ref in apa style

[Lars Bjørndal]

On Thu, May 25, 2017 at 05:36:07PM +0100, Eric S Fraga wrote:
> On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
> > Hi, list!
> >
> > I'm currently writing an exam in org-mode with org-ref, installed from
> > elpa. I think the institution expects to get the referances in apa
> > style. So I wonder if I can do that, and how I can do it.
> 
> Have you tried?  What happens?

Well, to be honest, I don't know what to replace the line in question
with. I'm a novice both in LaTeX and in org-mode/org-ref.

Lars

Re: Citations with org-ref in apa style

[John Kitchin]

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

I guess you should change
#+LATEX_HEADER:
 \usepackage[citestyle=authoryear-icomp,bibstyle=authoryear,
 hyperref=true,backref=false,maxcitenames=3,url=true,
backend=biber,natbib=true]
 {biblatex}

to

#+LATEX_HEADER: \usepackage[american]{babel}

#+LATEX_HEADER: \usepackage{csquotes}#+LATEX_HEADER:
\usepackage[style=apa]{biblatex}#+LATEX_HEADER:
\DeclareLanguageMapping{american}{american-apa}

I am not a biber user. See
http://mirrors.ibiblio.org/CTAN/macros/latex/contrib/biblatex-contrib/biblatex-apa/biblatex-apa.pdf
for more details.


John

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


On Thu, May 25, 2017 at 3:57 PM, Lars Bjørndal <lars@lamasti.net> wrote:

> On Thu, May 25, 2017 at 05:36:07PM +0100, Eric S Fraga wrote:
> > On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
> > > Hi, list!
> > >
> > > I'm currently writing an exam in org-mode with org-ref, installed from
> > > elpa. I think the institution expects to get the referances in apa
> > > style. So I wonder if I can do that, and how I can do it.
> >
> > Have you tried?  What happens?
>
> Well, to be honest, I don't know what to replace the line in question
> with. I'm a novice both in LaTeX and in org-mode/org-ref.
>
> Lars
>
>

[-- Attachment #2: Type: text/html, Size: 3911 bytes --]

Re: Citations with org-ref in apa style

[Lars Bjørndal]

On Thu, May 25, 2017 at 08:36:28PM -0400, John Kitchin wrote:
> I guess you should change
> #+LATEX_HEADER:
>  \usepackage[citestyle=authoryear-icomp,bibstyle=authoryear,
>  hyperref=true,backref=false,maxcitenames=3,url=true,
> backend=biber,natbib=true]
>  {biblatex}
> to
> #+LATEX_HEADER: \usepackage[american]{babel}
> #+LATEX_HEADER: \usepackage{csquotes}
> #+LATEX_HEADER: \usepackage[style=apa]{biblatex}
> #+LATEX_HEADER: \DeclareLanguageMapping{american}{american-apa}

Thank you very much!

After a bit of fiddling, I got it. The headers I have now, and which
work, are:

#+LANGUAGE: no
#+OPTIONS: toc:nil timestamp:nil time:nil
#+LATEX_CLASS: article
#+LaTeX_CLASS_OPTIONS: [a4paper,norsk,12pt,listings-bw,microtype]
#+LATEX_HEADER: \usepackage{babel}
#+LATEX_HEADER: \usepackage{fancyhdr}
#+LATEX_HEADER: \usepackage{csquotes}
#+LATEX_HEADER: \usepackage[backend=biber,style=apa]{biblatex}
#+LATEX_HEADER: \DeclareLanguageMapping{norsk}{norsk-apa}

#+LATEX_HEADER: \usepackage{lastpage}
#+LATEX_HEADER: \usepackage{hyperref}
#+LATEX_HEADER: \usepackage{url}
#+Latex_header: \addbibresource{~/mydoc/smartlaring/ref.bib}
#+BIBLIOGRAPHY: ~/mydoc/smartlaring/ref apa
#+Latex_header: \linespread{1.4}

Again, thank you!

Lars

>   On Thu, May 25, 2017 at 05:36:07PM +0100, Eric S Fraga wrote:
>   > On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
>   > > Hi, list!
>   > >
>   > > I'm currently writing an exam in org-mode with org-ref,
>   installed from
>   > > elpa. I think the institution expects to get the referances in
>   apa
>   > > style. So I wonder if I can do that, and how I can do it.
>   >
>   > Have you tried?  What happens?
>   Well, to be honest, I don't know what to replace the line in
>   question
>   with. I'm a novice both in LaTeX and in org-mode/org-ref.
>   Lars
> 
> References
> 
> 1. http://mirrors.ibiblio.org/CTAN/macros/latex/contrib/biblatex-contrib/biblatex-apa/biblatex-apa.pdf
> 2. http://kitchingroup.cheme.cmu.edu/
> 3. mailto:lars@lamasti.net

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

[Lars Bjørndal]

On Fri, May 26, 2017 at 01:24:03PM +0200, Lars Bjørndal wrote:

[...]

> After a bit of fiddling, I got it. The headers I have now, and which
> work, are:
> 
> #+LANGUAGE: no
> #+OPTIONS: toc:nil timestamp:nil time:nil
> #+LATEX_CLASS: article
> #+LaTeX_CLASS_OPTIONS: [a4paper,norsk,12pt,listings-bw,microtype]
> #+LATEX_HEADER: \usepackage{babel}
> #+LATEX_HEADER: \usepackage{fancyhdr}
> #+LATEX_HEADER: \usepackage{csquotes}
> #+LATEX_HEADER: \usepackage[backend=biber,style=apa]{biblatex}
> #+LATEX_HEADER: \DeclareLanguageMapping{norsk}{norsk-apa}
> 
> #+LATEX_HEADER: \usepackage{lastpage}
> #+LATEX_HEADER: \usepackage{hyperref}
> #+LATEX_HEADER: \usepackage{url}
> #+Latex_header: \addbibresource{~/mydoc/smartlaring/ref.bib}
> #+BIBLIOGRAPHY: ~/mydoc/smartlaring/ref apa
> #+Latex_header: \linespread{1.4}

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
following error from pdflatex:

! LaTeX Error: Can be used only in preamble.

See the LaTeX manual or LaTeX Companion for explanation.
Type  H <return>  for immediate help.
 ...

l.368 \bibliography
          {ref}
?

If I type H, I get: Your command was ignored.

What can I do to fix this?

Thanks and regards, Lars


> >   On Thu, May 25, 2017 at 05:36:07PM +0100, Eric S Fraga wrote:
> >   > On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
> >   > > Hi, list!
> >   > >
> >   > > I'm currently writing an exam in org-mode with org-ref,
> >   installed from
> >   > > elpa. I think the institution expects to get the referances in
> >   apa
> >   > > style. So I wonder if I can do that, and how I can do it.
> >   >
> >   > Have you tried?  What happens?
> >   Well, to be honest, I don't know what to replace the line in
> >   question
> >   with. I'm a novice both in LaTeX and in org-mode/org-ref.
> >   Lars
> > 
> > References
> > 
> > 1. http://mirrors.ibiblio.org/CTAN/macros/latex/contrib/biblatex-contrib/biblatex-apa/biblatex-apa.pdf
> > 2. http://kitchingroup.cheme.cmu.edu/
> > 3. mailto:lars@lamasti.net
> 

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

[John Kitchin]

I think what you want in this case is to redefine how the bibliography
link is exported.

Maybe something like this:

(org-link-set-parameters
 "bibliography"
 :export
 (lambda (bibfile desc format)
   (cond
    ((eq format 'html) (org-ref-get-html-bibliography))
    ((eq format 'latex)
     ""))))

That way you will get nothing exported for latex (so you have to keep
the same heading info for biblatex), and you get the html bibliography
too.

Lars Bjørndal writes:

> On Fri, May 26, 2017 at 01:24:03PM +0200, Lars Bjørndal wrote:
>
> [...]
>
>> After a bit of fiddling, I got it. The headers I have now, and which
>> work, are:
>>
>> #+LANGUAGE: no
>> #+OPTIONS: toc:nil timestamp:nil time:nil
>> #+LATEX_CLASS: article
>> #+LaTeX_CLASS_OPTIONS: [a4paper,norsk,12pt,listings-bw,microtype]
>> #+LATEX_HEADER: \usepackage{babel}
>> #+LATEX_HEADER: \usepackage{fancyhdr}
>> #+LATEX_HEADER: \usepackage{csquotes}
>> #+LATEX_HEADER: \usepackage[backend=biber,style=apa]{biblatex}
>> #+LATEX_HEADER: \DeclareLanguageMapping{norsk}{norsk-apa}
>>
>> #+LATEX_HEADER: \usepackage{lastpage}
>> #+LATEX_HEADER: \usepackage{hyperref}
>> #+LATEX_HEADER: \usepackage{url}
>> #+Latex_header: \addbibresource{~/mydoc/smartlaring/ref.bib}
>> #+BIBLIOGRAPHY: ~/mydoc/smartlaring/ref apa
>> #+Latex_header: \linespread{1.4}
>
> 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
> following error from pdflatex:
>
> ! LaTeX Error: Can be used only in preamble.
>
> See the LaTeX manual or LaTeX Companion for explanation.
> Type  H <return>  for immediate help.
>  ...
>
> l.368 \bibliography
>           {ref}
> ?
>
> If I type H, I get: Your command was ignored.
>
> What can I do to fix this?
>
> Thanks and regards, Lars
>
>
>> >   On Thu, May 25, 2017 at 05:36:07PM +0100, Eric S Fraga wrote:
>> >   > On Thursday, 25 May 2017 at 11:47, Lars Bjørndal wrote:
>> >   > > Hi, list!
>> >   > >
>> >   > > I'm currently writing an exam in org-mode with org-ref,
>> >   installed from
>> >   > > elpa. I think the institution expects to get the referances in
>> >   apa
>> >   > > style. So I wonder if I can do that, and how I can do it.
>> >   >
>> >   > Have you tried?  What happens?
>> >   Well, to be honest, I don't know what to replace the line in
>> >   question
>> >   with. I'm a novice both in LaTeX and in org-mode/org-ref.
>> >   Lars
>> >
>> > References
>> >
>> > 1. http://mirrors.ibiblio.org/CTAN/macros/latex/contrib/biblatex-contrib/biblatex-apa/biblatex-apa.pdf
>> > 2. http://kitchingroup.cheme.cmu.edu/
>> > 3. mailto:lars@lamasti.net
>>


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