Re: Very wide SC-format spreadsheet only imports first 256 cols

On Thu, 2010-10-07 at 14:11 -0400, Jonathan Lovelace wrote:
I have a 343 column by 600 row SC format spreadsheet that I'd like to have 
in a more modern format. As Gnumeric is the only program I can find that 
can read SC spreadsheets and export more widely supported formats, I hope 
to use it for the purpose. (I'm using 1.10.6 on Gentoo Linux, but the 
behavior I describe below also appears in version 1.10.11.)

When I attempt to open this spreadsheet, it only 
gives me the first 256 columns, with no error dialogs but with several 
messages (along with the warnings that the importer left "unhandled" SC's 
column width, cell format, and UI option "directives") on standard 
error like this:

CRITICAL **: sheet_cell_create: assertion `col < gnm_sheet_get_max_cols 
(sheet)' failed

The Gnumeric FAQ claims that it supports more than 256 columns, but the 
answer to that question says that "you can right-click the sheet tab and 
select 'Resize...'"

Is there some way to import the whole spreadsheet?

The sc importer was written long before we increase the column numbers
and it appears to have 256 columns hardcoded. Most likely all that is
needed is to increase that number (in plugins/sc/sc.c) to 512 and
recompile. You will loose things like  column width, cell format etc
since their import is simply not implemented.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]