GNOME Bugzilla – Bug 50881
can't import CSV file with >256 columns
Last modified: 2004-12-22 21:47:04 UTC
Package: gnumeric Version: 0.61 Hi, I tried out gnumeric for the first time because we ran into an Excel limit when importing a comma-separated file (at most 256 columns). Unfortunately gnumeric choked on it too. I understand it's not done yet, but just wanted to say that support for >256 columns would be a pretty compelling reason to switch. - Brian ------- Bug moved to this database by unknown@bugzilla.gnome.org 2001-02-14 14:15 ------- The original reporter (skybrian@savagebeast.com) of this bug does not have an account here. Reassigning to the exporter, unknown@bugzilla.gnome.org. Reassigning to the default owner of the component, jgoldberg@home.com.
Other things currently take priority, but doing this in your own tree should not be hard -- at least up to 26*27 (== up to column ZZ). There might be performance issues. The style code might like 5^4 better.
Assigned to me since I am working on the text importer and (at least the import aspect) should be easily fixable.
This could probably be solved within the text importer since we could use more than 1 sheet.
what is the status of this bug ? I am using 1.09 and when importing text with more that 255 columns, gnumeric wraps the data around to a new line, which make it pretty much useless. Chris.
It's dormant, but not forgotten. (Almer was working on this, but it looks like real life has swallowed him.)
Relatedly, the stf importer should allow one to mark columns to be thrown away during import. (Think of it as a special format or something like that.)
I am 75% towards being able to select the columns to be imported.
So, while we still can only import as many columns as we have in the sheet (256 normally), we can now choose which columns to import, so the main issue of this bug is fixed.