[EMAIL PROTECTED] wrote:
Hi, I'm using LyX 1.5.3 and have a situation where I need to put
spreadsheet data into tables in LyX -- several of them actually. I'm
able to paste the spreadsheet data into LyX. But so far I haven't
figured out a way other than the tedious method of cutting and pasting
every cell's contents one-by-one into place in the table.
Is there any way I can at least do columns or rows at a time if not a
the whole block of columns and rows at once?
There is another option too.
Gnumeric can export a spreadsheet as latex code for a longtable.
This works for spreadsheets made with gnumeric, openoffice and excel.
The entire thing can then be imported by importing the latex file.
This works fine for text and numbers, I don't know about bar graphs and
such.
I made an "external inset" that automates this process - there has been no
interest so far though.
Helge Hafting