Text import & a bug

[Nick Lamb <njl98r ecs soton ac uk>]

Thoughts on text import, but first an actual bona fide bug which no doubt
will make Jody go "doh" and he'll have a one line fix :)

A1 is text "Foo bar baz"
A2 is blank
A3 is text "Qux quux quuux"

Select A1:A3
Data -> Text to columns...

Click forward through all the default settings...

"Error: Invalid Unable to paste : 'destination does not have an even
multiple of source rows (3 vs 2)

Try selecting a single cell or an area of the same shape and size.'


---

The smart default text handling does a very good job on CSV data of the
sort created by a Perl script somewhere, or exported from some other
database or spreadsheet program. This represents the most important type
of text import because it's rarely a "one off" so we need to make it
completely painless.

However if an oh-so-clever web site calls these files .XLS in order to
trigger Windows into using the "right" software to examine them then
Gnumeric acts dumb. Are there any _real_ files that don't match the
excel_file_probe() but do actually contain XL format data?

Example: http://www.tpc.org/information/results_spreadsheet.asp

Nick.