Importing a spreadsheet is something I very often do in LyX but I use quite a different way!
Usually my finished product is a pdf file, harder to edit and respecting exactly the formatting I want. Here is what I do in a few words: printing the spreadsheet table in a Postscript file, convert it in encapsulated Postscript (eps or epsi) and insert it as an image in LyX. When exported in pdf, the fonts are embedded, the table is exactly as it was in the spreadsheet and, as it is vectorial, il can fit any space I want in the page. So here is what I do: 1. print the spreadsheet table in a file, be sure to avoid header or footer unless you really need them; 2. convert the printed ps file in eps format in a terminal: ps2epsi the_printed_file.ps 3. the table is cropped precisely in the epsi file with ps2epsi, if you leave a header then the header will be part of the cropped table, don't forget it! 4. In LyX, simply insert the eps file as an image. Don't forget to keep the ratio while giving the wanted width or height of the table. 5. Export the resulting LyX file in pdf and voilà ! Try to be uniform while creating the table, respect the look and feel of the document you want to insert the table into, especially use the same font. This way of doing things can be done also directly by inserting a pdf file in the LyX document (using ERT), but I prefer the eps way as it gives me more control easyly. Raymond -- Édité et transmis avec des logiciels libres sous Linux !
