Apache OpenOffice (AOO) Bugzilla – Issue 35901
Spreadsheet ignores sheets above 256
Last modified: 2013-08-07 15:12:27 UTC
When importing Excel file with 300 sheets, Spreadsheet opens only 256 of them (other sheets were ignored).
Hi, this is not a bug because Calc currently is capable to handle 'only' 256 Sheets. So I reflagged it as enhancement request and re-assigned it. Frank
I want to transfer an Excel2000-file with 320 Sheets into an Calc 2.0 - File - is this possible?
Hello from Russia! Help Us! We are using documents with 300 and more sheets. Many organizations in our country also used many-sheets documents. If you wish to support XLS format it would be useful if you made it more effective at least in terms of number of pages. ==== Помогите нам! Мы используем документы с кол-вом листов 300 и более. Множество организаций в нашей стране также используют многостраничные документы. Если вы претендуете на поддержку формата XLS, было бы неплохо сделать её более полноценной хотябы в случае с количеством листов. ====
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
There are practical workarounds to this limitation, ie, splitting the file into smaller files with fewer sheets, etc. That being said, it is difficult to convince the older denizens of some nonprofit organizations to change their file structures since their response is something like, "I didn't have to do that with Excel. Why do you want to switch us to OpenOffice again?" Some people like to have a spreadsheet with one sheet per day of the year. That's more than 100 sheets over this hard-coded limitation. It would be nice to hit a memory limit before hitting an arbitrary limit in the program. I have voted this up, as I feel this is a necessary improvement to help OpenOffice.org compete with Microsoft Office. Surf Wisely.
To increase the max number of the sheets, you must increase the MAXTABCOUNT variable in file: http://svn.services.openoffice.org/opengrok/xref/Current%20(trunk)/sc/inc/address.hxx
*** Issue 116165 has been marked as a duplicate of this issue. ***
I would have thought 256 spread tabs would be enough, but I recently attempted to open the County of Santa Clara Registrar of Voters Statment of Vote for the November 2, 2010 General Election in .xls format and the open did not load all the data because it hit a limit of 256 spread sheet pages. It loaded only the first 256 spread sheet tabbed pages, thus preventing my investigation of accountability of the General Election Voting :-)
The reason why this issue couldn't be easily solved is that there are some fixed- size arrays and loops, so they would have to look for performance implications first.
Why not create then an option with a larger sized spreadsheet with possible performance degradation ? That is always better than an insufficient smaller spreadsheet without degradation.