GNOME Bugzilla – Bug 139385
when a text file with > MAX_COLS is loaded, a warning should be given
Last modified: 2004-12-22 21:47:04 UTC
Load into gnumeric a CSV file with > 256 columns. The data are silently truncated.
Well, I would say that in the configuration dialog for the text import the fact that only some of the columns are selected for input should be made more visible.
Agreed. we could certainly be more vocal when the initial selection is limited by the number of available columns.
Well, if started from the console, a whole lot of comments are given (too many). Besides, in scientific environments the limitation of Excel to 256 columns is ridiculed by everybody. So people do Access databases only to select columns in there (like: give me the means of all measurements and leave the medians). I was shocked to find KOffice totally unusable for larger files and to find Gnumeric in total compatibiliy with the enemy. in this respect ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed ** (gnumeric:2154): CRITICAL **: file ../../src/cell.c: line 215 (cell_set_text): assertion `cell != NULL' failed ** (gnumeric:2154): CRITICAL **: file ../../src/sheet.c: line 2443 (sheet_cell_new): assertion `col < SHEET_MAX_COLS' failed
1. Those error messages should obviously not come out that way. 2. If you want more columns, it's just a recompilie away.
We now no longer spew error messages on stderr, just a single ** (gnumeric:21094): WARNING **: There are more columns of data than there is room for in the sheet. Extra columns will be ignored. This, of course, isn't ideal, but better than nothing.
fixed in cvs head