[KLUG Members] OOo & 32,000 lines

[Andrew Thompson]

On Tue, 2005-02-15 at 22:22, Dennis wrote:
> Adam Tauno Williams wrote:
> > 
> > > > Anyone know of a way to disable/enable/workaround OOo 32,000 row
> > > > spreadsheet limitation?
> [...]
> > 
> > Since we are the receiver we have to be able to open them.  It seems odd
> > that gnumeric can open a file that OOo can't.
> > 
> 
> 32000 has always been the limit in OOo 1.x.  OOo 2.0 will overcome
> that limit.  The snapshot builds heading to 2.0 are capable of
> handling 65536 rows.

65,535 is the upper limit for MS Excel, I believe, although it MIGHT be
possible to set it for a higher limit. Unless it is, you shouldn't be
getting spreadsheets any MORE than twice that size, unless OOo's limit
is EXACTLY 32,000 rows (and then, not by much).

If you'd prefer to work with it in OOo instead of Gnumeric, you might
just use Gnumeric to split the larger sheets and put the lower halves on
new sheets. That's about all I could suggest.

-- 
Andrew Thompson <tempes at ameritech.net>
The Imagerie