Difference between revisions of "Calc/hacks/number of rows"
(hack: more than 64k rows or 256 columns) |
m |
||
| (13 intermediate revisions by 7 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Note| As of DEV300_m84 the number of rows was increased to 1048576 (1M).}} | |
| − | + | ||
| − | + | Regard this article as historical, though the content is still applicable to columns or in case you want to increase the number of rows to 2097152 (2M ;-) | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | Now and then people ask whether increasing the row limit above 64k lines or the column limit above 256 columns for OpenOffice.org version 2.4 or [http://www.oooninja.com/2008/03/openofficeorg-30-new-features.html 1024 columns for 3.0] would be possible. | |
| − | + | ||
| − | + | ||
| − | + | Well, it depends on your goal. For personal use, you may set <code>MAXROWCOUNT_DEFINE</code> in <tt>sc/inc/address.hxx</tt> to | |
| − | + | a different value, multiple of 128, then recompile the application respectively the <tt>libsc680*.so</tt> and shove it under your existing installation. However, doing so implies that you don't save to any binary file format like Excel or whatsoever, otherwise you risk loss of data. You'll also encounter drawing layer misfits in higher row numbers, may experience performance problems, and there maybe other quirks. It generally works for data and formulas, but otherwise is completely untested. | |
| − | + | ||
| − | + | ||
| − | + | For the number of columns, the same applies to the <code>MAXCOLCOUNT_DEFINE</code> in <tt>sc/inc/address.hxx</tt>, except that the value must be a multiple of 16 instead. | |
| − | + | ||
| − | + | ||
| − | [[Category:Calc]] | + | A successful proof of concept was done by Laurent Godard, using 2,000,000 rows and 32,000 columns, resulting in the lower right corner cell address '''AUHT2000000''' ... see [https://web.archive.org/web/20100325205259/http://blogs.nuxeo.com/dev/2006/08/the-spreadsheet-next.html http://blogs.nuxeo.com/dev/2006/08/the-spreadsheet-next.html] |
| + | |||
| + | Please note again that this is a ''hack''. Although it may serve you for some data crunching, exchanging documents with other releases or applications will not work. | ||
| + | |||
| + | <s>However, we should implement this expansion properly, also to be able to handle larger spreadsheet documents created with other applications. There are RFEs for this, {{bug|30215}} for number of rows and {{bug|86049}} for number of columns.</s> Fixed in OOo 3.3.0 | ||
| + | |||
| + | [[Category:Calc|Hack]] | ||
| + | [[Category:Hack]] | ||
Latest revision as of 12:30, 16 February 2024
 |
As of DEV300_m84 the number of rows was increased to 1048576 (1M). |
Regard this article as historical, though the content is still applicable to columns or in case you want to increase the number of rows to 2097152 (2M ;-)
Now and then people ask whether increasing the row limit above 64k lines or the column limit above 256 columns for OpenOffice.org version 2.4 or 1024 columns for 3.0 would be possible.
Well, it depends on your goal. For personal use, you may set MAXROWCOUNT_DEFINE in sc/inc/address.hxx to
a different value, multiple of 128, then recompile the application respectively the libsc680*.so and shove it under your existing installation. However, doing so implies that you don't save to any binary file format like Excel or whatsoever, otherwise you risk loss of data. You'll also encounter drawing layer misfits in higher row numbers, may experience performance problems, and there maybe other quirks. It generally works for data and formulas, but otherwise is completely untested.
For the number of columns, the same applies to the MAXCOLCOUNT_DEFINE in sc/inc/address.hxx, except that the value must be a multiple of 16 instead.
A successful proof of concept was done by Laurent Godard, using 2,000,000 rows and 32,000 columns, resulting in the lower right corner cell address AUHT2000000 ... see http://blogs.nuxeo.com/dev/2006/08/the-spreadsheet-next.html
Please note again that this is a hack. Although it may serve you for some data crunching, exchanging documents with other releases or applications will not work.
However, we should implement this expansion properly, also to be able to handle larger spreadsheet documents created with other applications. There are RFEs for this, Issue 30215 for number of rows and Issue 86049 for number of columns. Fixed in OOo 3.3.0
