copying spreadsheet data into Lyx

[Russell Davie]

Hi
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?
cheers
Russell