Issue 35901 - Spreadsheet ignores sheets above 256
Summary: Spreadsheet ignores sheets above 256
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial with 18 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 116165 (view as issue list)
Depends on:
Reported: 2004-10-20 19:49 UTC by stasik2002
Modified: 2013-08-07 15:12 UTC (History)
6 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description stasik2002 2004-10-20 19:49:24 UTC
When importing Excel file with 300 sheets, Spreadsheet opens only 256 of them
(other sheets were ignored).
Comment 1 frank 2004-10-21 08:11:45 UTC

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.

Comment 2 donkarlos 2005-10-31 09:31:06 UTC
I want to transfer an Excel2000-file with 320 Sheets into an Calc 2.0 - File -
is this possible?
Comment 3 allesv 2006-09-27 06:51:07 UTC
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 
Помогите нам! Мы используем документы с кол-вом листов 300 и более. Множество 
организаций в нашей стране также используют многостраничные документы. Если вы 
претендуете на поддержку формата XLS, было бы неплохо сделать её более 
полноценной хотябы в случае с количеством листов.
Comment 4 bettina.haberer 2010-05-21 14:47:32 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 5 dolst 2010-10-04 14:20:17 UTC
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
compete with Microsoft Office.
Surf Wisely.
Comment 6 gang65 2010-11-04 00:28:08 UTC
To increase the max number of the sheets, you must increase the MAXTABCOUNT
variable in file:

Comment 7 Marcus 2010-12-18 16:32:02 UTC
*** Issue 116165 has been marked as a duplicate of this issue. ***
Comment 8 johnksellers 2010-12-18 22:01:43 UTC
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 :-)
Comment 9 gang65 2010-12-19 18:47:13 UTC
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 
Comment 10 meijn 2010-12-19 20:33:14 UTC
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.