I'm having some trouble with the Insert→File→External Material dialog for a LibreOffice Calc spreadsheet I'd like to embed into my Lyx document. The spreadsheet is 9 columns and about 30 rows (but will extent to probably over 50 when I'm done filling in all the data). Lyx throws an error on export (I'm using XeLaTeX), saying that the table exceeds the maximum width of 19 feet, and the exported pdf stops at the chapter containing the spreadsheet.
Some questions:
How can I format the embedded spreadsheet so it actually fits?
Can I add captions, headers, footers, etc. to the resulting longtable?
Can I exert any other control over the look of the spreadsheet?
Thanks for the help.
EE
LyX ⇒ Import Calc into Lyx?
NEW: TikZ book now 40% off at Amazon.com for a short time.

Import Calc into Lyx?
As far as I know, inserting a spreadsheet into LaTeX is not going to work in a very simple way. There is now a package to include a spreadsheet into LaTeX. Take a look at the following link:
https://tex.stackexchange.com/questions ... e-as-input
https://tex.stackexchange.com/questions ... e-as-input
OS: Debian/GNU Linux; LaTeX System : TeXLive; Editor : Vim
-
- Posts: 94
- Joined: Wed Sep 07, 2011 3:14 pm
Re: Import Calc into Lyx?
There is, but that package does not work with PDFLatex or XeLaTeX (both of which I use). I'm not sure if that means I (still) can't load ods files with the embedded object option from PDFLatex, or if that means I have to use another tex interpreter than XeLaTeX (which doesn't work for me: I need xelatex for a bunch of other output stuff).
hrm. Any other ideas?
hrm. Any other ideas?