> How can spreadsheet data be copying into LyX quickly? > I can't get Open Office or Gnumeric to do this easily. > Surely there must be a better way than one cell at a time? There are several approaches: http://wiki.lyx.org/Tips/CopyTablesFromSpreadsheets
I personally use for my tables the csv2lyx converter: ftp://ftp.lyx.org/pub/lyx/contrib/tools/csv2lyx-1.0.0.tar.gz If you are on Linux just save the table as CSV and then adapt the following shell script to your table: 1. in Gnumeric, OOCalc, Excel export the table with 1. col separator ; 2. text separator none 2. If you use special characters like umlauts then do a conversion iconv -f UTF-8 -t ISO-8859-15 -o TABLE.csv TABLE_latin1.csv 3. you may replace units like € with \texteuro 4. runs the perl script csv2lyx example: csv2lyx TABLE_latin1.csv -separator=";" --grid --border \ --title="TABLETITLE" --label="TABLELABEL" --output=TABLE_latin1.lyx 5. open the table-file you created and adjust it: set language to the language of your document, adjust col width, etc. 6. insert at the right place in the main document. Sounds complicated but is very efficient once you get used to it! Trade off: it doesn't preserve formats. Once I get some minutes I'll enter this workflow in the above mentioned wiki page... Good luck!
