OpenOffice Text Files That Are Larger Than 65,536 Rows Cannot Open / Imported
This sucks, Open office 2.3 spreadsheet cannot open or import text files that are larger than 65,536 rows. Basically, I need 100k rows. However, it is possible to recompile OO to extend rows limitation. From the OO wiki hack page:
Well, it depends on what your goal is. For personal use you may set MAXROWCOUNT_DEFINE in sc/inc/address.hxx to a different value, multiple of 128, and 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 may be other quirks lurking. Note that 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, just that the value must be a multiple of 16 instead.
My text file is truncated at 65,536 and I was dumped with the following error message:

I'm going to recompile my OO. Another good option is using MySQL. However, I'm not in mood to write a php / python scripts to just create graphs and other stuff.
Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
You may also be interested in other helpful articles:
- Download of the day: OpenOffice.org 2.1 with brand new templates
- IBM to help and promote OpenOffice.org office suite
- Download of the day: OpenOffice 3.0 beta Software
- QD#4: America’s Dumbest Criminals, OpenOffice.org Premium, Firefox 2 beta, Security Engineering book, 21 Tactics to Increase Blog Traffic
- Download of the day: OpenOffice.Org 2.3 office suite for Linux / Windows / Mac OS X
Discussion on This Article:
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Tags: error message, file format, oo, open office, openoffice, openoffice increase number of rows, performance problems, personal use, row numbers, spreadsheet



Thanks for the detailed instructions, however I think the title is a little misleading - I thought for a moment that you’ve described a procedure to patch live running kernel (in memory) - without restarting the machine.