LyX wiki | Examples / SpreadsheetExternalInset

Categories: Lyx20, Example, Spreadsheet, External inset

<< | Page list | >>

Example of using spreadsheets as external insets in a LyX document

Files

A PDF file that shows examples of included spreadsheets, and also explains how to do this.
The LyX 2.0 file containing the example. Tested & works with LyX 2.1.3 also.
Gnumeric spreadsheet included in the example
Openoffice spreadsheet included in the example
Excel spreadsheet included in the example
Multi-page spreadsheet included in the example

To try it out, download the spreadsheets and the LyX file. Put all in the same directory, then edit the LyX file with LyX 2.0.

LyX 2.0 & 2.1 supports spreadsheets made with Gnumeric, Openoffice and Excel. You need to have gnumeric installed, no matter what kind of spreadsheet you use. This because the converter is part of gnumeric. NOTE: This works only if your document is in single-column mode--go to Document -> Settings -> Text Layout and make sure Two-column document is unchecked. Otherwise you will get a LaTeX error, "Package longtable Error: longtable not in 1-column mode."