exporting info to workbook

[Larary]

Excel supports only 256 columns so data in columns IW
through ZZ is not exported from the spreadsheet. Is this
problem fixed in excel 2002?

 

[EZ Money]

There are still only 256 columns*65,536 rows. If you have XL XP, just look
under help for the limits.

 

[Harlan Grove]

one can question if it really would be a fix? I have heard that after
Quattro Pro changed the boundaries of the rows / columns it became
more or less unusable.

It wasn't just the workbook size. It's flaky, but my experience with it is
crashes entering formulas in default size workbooks.

However, I also use Xess under Linux, and it provides over 1000 columns and
almost 100,000 rows, and I have yet to crash it. I haven't tried to build
gnumeric with more than 256 columns yet.

It *is* possible to write robust spreadsheets with more than 256 columns.
Microsoft has even written a spreadsheet web component that could be the
core of a much large grid spreadsheet, but they haven't made it into a
full-blown application. (Whether it's robust or not I have no idea.)

 

[Hank Scorpio]

Hank,


one can question if it really would be a fix? I have heard that after
Quattro Pro changed the boundaries of the rows / columns it became
more or less unusable.

"Unusable" may be an exaggeration; I've used it (Version 10, which
came with my notebook) to get around the 65,536 row limit on occasion
and haven't encountered any stability issues with it. I can get what I
need to do done, but admittedly I've never "pushed the envelope" with
it. I find it to be a somewhat frustrating product to use at times and
its on-line Help is fairly brainless, but had I the time or
inclination to learn the QP way of doing things I may feel
differently. Since I have neither, it's just a supplement to the three
versions of Excel that reside on that machine.