On Tuesday 13 December 2005 09:54 am, Henrik Sundberg wrote: > 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). > > /$ Specifically, 32 bits is a little less than 4.3 million (4,300,000) and 64 bits is about 8.5 million.
Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
