excel2latexopen-officetables
I've installed extension Calc2LaTeX to convert OO tables into LATEX. But I don't see any extra button on OO to get LATEX CODE;
In Extension manage of OO, it's showing Calc2Latex in Enabled format.
Can you please help me to understand, how to get Latex code for Open office excel?
I implemented this for a large R&D lab. We produced several hundred (if not thousand) documents per year, and the LaTeX Users' community there wanted to be able to produce documents using 'tex as well as WYSIWYG software.
The OP was right in that a well-defined workflow is essential. Part of this is the process, but you may also need to think about training and using a common repository, and how to implement corporate design.
We implemented a process that allowed people to work in LaTeX and then switch to .docx for collaborators.
nag package to make sure that you (and other users) can see that those packages are not deprecated.N.B. Using one of the web-based editors like sharelatex.com or overleaf.com can remove the need for 5-7, especially now that they have rather good review tools.
There were a couple of challenges we had to face to get this adopted.
The one thing that is still causing trouble is 508-compliance. I have been working (slowly) on using the pdfcomment package to add tooltips and modifying the accessibility package so that documents are accessible. My test PDF documents sometimes pass automated testing in Adobe Acrobat...
I've put a set of demo documents in a Github repository which may be helpful.
3 Dec 2017: Originally I suggested the use of latex2rtf instead of Pandoc. I am now editting this answer to suggest Pandoc as I find Pandoc is kept up to date, works well, and I like the flexibility to choose from many more input and output file types.
tex4ht is installed with all major TeX distributions, so you don't need custom copies of tex4ht.sty and other packages. Just try to run the command
mk4ht oolatex test.tex
You also don't need to include any custom code in your TeX document, all tex4ht configurations are included by the calling script automatically.
Your TeX file should look like:
\documentclass{article}
\begin{document}
Minimal example \LaTeX\
\end{document}
This is the result in LibreOffice:
Best Answer
That's fairly easy. Open any spreadsheet and select the rows/columns you want to appear in your table. Go to "Extras / Execute Macro / My Macros/Calc2Latex". Click on "Main" in the right side and "execute". It can take a few seconds before you will see the LaTeX dialogue which will allow you further settings.
(I hope the menu wording is similar in OpenOffice: I am using the German version of LibreOffice 4.1)