2005/12/13, Andrew Douglas Pitonyak <[EMAIL PROTECTED]>: > Wolfgang Keller wrote: > > > Hello, > > > > has the sourcecode of OO Calc been foreseen to be recompiled with an > > appropriate option to support more than 64k rows and more than 256 > > columns (and more than 256 sheets)? > > > > Gnumeric, for example, allows this... > > > > And, quite honestly, 64k rows and 256 column is _nothing_ for OLAP or > > statistical analysis. > > > > TIA, > > > > Wolfgang Keller > > Wolfgang, > > This is a very good question and unfortunately, the answer is no. It was > already a big undertaking to allow a sheet to support 64K rows rather > than 32K rows. The problem is that the program is specifically written > to assume a certain number of rows, columns, and sheets as the maximum. > > Consider the problem of allowing more than 256 columns for a moment. > There is a lot of code in a lot of places that assume that there will > never be anything more than this. Even worse, the type of variable to > hold the number of columns has also been chosen to optimize speed and > size of storage. To increase the number of columns, every instance of > this must also be changed. It is a difficult and error prone process if > it was not assumed from the start.... > > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > My Book: http://www.hentzenwerke.com/catalog/oome.htm > Info: http://www.pitonyak.org/oo.php > See Also: http://documentation.openoffice.org/HOW_TO/index.html > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
I read the references supplied by Douglas. I.e. http://sc.openoffice.org/row-limit.html and http://qa.openoffice.org/issues/show_bug.cgi?id=30215 . The first reference gives me the impression that the hard work is done. The 16-bit types (maximizing the row number to 64K) are replaced by 32-bit types (I think the type for columns was changed as well). There seems to be two reasons for not allowing more rows today: 1) The issue was about MSO compatibility (solved). 2) OOo is too slow as it is. When this is fixed (which seems to be within the horizon) the number of rows can be practically unlimited (64 bits represent huge numbers). /$ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
