LyX ⇒ Import Calc into Lyx?

[ExecutorElassus]

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

[mas]

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

[ExecutorElassus]

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?