2005/12/13, Dan Lewis <[EMAIL PROTECTED]>: > 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] > > Actually both are bigger: 2^32 = 4 294 967 296
2^64 = 18 446 744 073 709 552 000 /$ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
