On 12/08/2010 05:11 PM, Helge Hafting wrote:
This patch lets LyX 2.0 use spreadsheets as external insets:
* gnumeric spreadsheets
* openoffice spreadsheets
* excel spreadhsheets
This is done using the "ssconvert" utility that comes with gnumeric,
so it is necessary to have gnumeric even if the spreadsheets used
are made with openoffice/excel.
The ssconvert utility does not execute macros, so there should be
no new risk of macro viruses.
Spreadsheets are imported as longtables, so a spreadsheet longer
than a page will still work fine.
PDF created with patched LyX 2.0, with included spreadsheets:
http://www.aitel.hist.no/~helgehaf/sw/lyxsheet/sheet.pdf
The .lyx file (only works with patched LyX 2.0):
http://www.aitel.hist.no/~helgehaf/sw/lyxsheet/sheet.lyx
The included spreadsheets:
http://www.aitel.hist.no/~helgehaf/sw/lyxsheet/sheet.gnumeric
http://www.aitel.hist.no/~helgehaf/sw/lyxsheet/sheet.ods
http://www.aitel.hist.no/~helgehaf/sw/lyxsheet/sheet.xls
The patch touches 3 files:
src/LaTeXFeatures.cpp The hhline latex package is necessary
lib/external_templates The external inset itself
lib/configure.py So Tools->Reconfigure will check for gnumeric
Use "Insert->File->External Material", then select GnumericSpreadsheet
to insert a spreadsheet into a document.
I hope this can be useful for LyX 2.0, spreadsheets are requested
now and then on the user list.
This looks quite good and simple.
Abdel.
