Here’s a test of a Google Spreadsheet posted here to this page.
Starting with an Open Office 3.0 spreadsheet Import failed. Then after converting the sheet to XLS it failed. Finally converting to CSV worked.
Notice that the Frozen Row 1 of the above sheet is not frozen.
I’ll try this again for publishing complex data to my websites. Since I can add formulae, it should be interesting.